TSO

About the AFG Screener

Professional investors have many ways to screen and narrow their list of constituents to create a focus list of companies they use to select from to develop their portfolios. In the industry, there are many screeners that are part of subscriptions to databases and investment tools, however, many of them do not provide guidance on the best screening methods to use. Created by The Applied Finance Group (AFG), the AFG Screener tool is a web-based company-screening application located on AFGView.com that is designed to save you time when narrowing your list of constituents. More importantly, AFG’s screener allows you to use proprietary variables that have been proven to outperform, helping investors make better investment decisions.

AFG’s Screener allows clients to find aggregate groups of companies that meet specific criteria from AFG’s entire global universe of over 14,000 securities. Using the Screener, one can find a list of companies that either match one of AFG’s preset screens or one based on a customized screen that you create.

The AFG Screener identifies attractive valuations, strong management teams, corporate performance, and the quality of earnings of a company as well as all traditional financial variables,

Because AFG’s Screener is web-based, clients can gain access from anywhere that has an internet connection, convenience and ease of “one-click screening” with our default screens, various forms of result presentations, and compatibility with Microsoft Excel for further analysis.

How to Use AFG’s Screener

Access AFG custom built screens that many clients regularly utilize that include AFG’s proprietary Economic Margin (EM), valuation and management quality variables along with many others.

Build your own custom screens using any variables you are familiar with such as price multiples and other accounting information by themselves or coupled with powerful AFG variables with just a few clicks of the mouse.

Once you have narrowed your list of constituents to those companies that meet your specific criteria you can easily upload your new list into AFG’s valuation model to analyze each company in greater detail or see how they rank vs. their peers on key AFG variables.

Default / Custom Screens

Whenever a new user is introduced to AFG’s Screener, they are provided with two default screens – AFG’s Default Buy screen and AFG’s Default Sell screen. Using these screens, one can filter companies based on AFG’s buy/sell criteria.

However, the AFG Screener is very intuitive allowing clients to create their own screens based on custom criteria. There are countless combinations that can be used to create a custom screens, as there are over 600 variables to choose from. AFG’s Screener tool can be used to list companies based on Indexes, Sectors, Industries, and previously created Portfolios.

Using Excel / Further Research

AFG screens can also be accessed using AFG’s Excel add-in to combine results with other spreadsheets or to create a report for your investment team. Exporting your information will give you more freedom to read, organize and document your data as well as pull in other variables within AFG’s Excel add-in to easily rank order your list of companies based on the same variables available within the screener.

Example Screen:

Below is a list of 12 companies that resulted from a quick screen that sought to identify those companies within the S&P 500 with attractive valuations, market cap above $1 billion, expected to improve EMs greater than sector peers, and that have a current stock price of under $30. Improving EMS and an attractive default AFG valuation rank is a good place to start when looking for the companies most likely to outperform. This is just one simple example of the capabilities of using AFG’s screener tool to select a focused list of stocks that are the most likely to outperform and a list that is worthy of more time spent on due diligence on the companies that meet the specified criteria.

The Applied Finance Group would also  like to invite professional investors to join AFG’s Market Forecast Project so you can better understand what your peers currently think about the market and cultivate the “wisdom of Crowds” into actionable investment ideas and themes.

Register to View Complete Market Review and Sector Analysis, it's FAST and FREE!

In recent weeks we have written several blogs (S&P 500 sector stock watch, Attractive stocks under $35, with potential investment opportunities, Solid S&P Value Companies, Cheapest Stocks In the S&P 500), discussing investment opportunities within the S&P 500. These stocks ideas all had favorable scores under The Applied Finance Group's (AFG’s) investment criteria, which includes economic performance, valuation, earnings quality and management’s ability to create shareholder wealth, among other criteria.

Another way that AFG identifies potentially attractive investments is through the use of its Value Expectations interface, which helps investors get a better understanding of the expectations embedded into stock prices. This interface allows us to understand the Sales Growth, EBITDA Margin, and Asset Turnover a company has to deliver in the future to justify its current trading price. In theory and in normal circumstances, if the imbedded future performance is very conservative relative to the company’s historical performance, the stock is regarded as undervalued. The table below displays the implied future Sales Growth (“Priced-in Sales Growth) of the companies we have recently recommended in our recent blogs, assuming their EBITDA Margins and Asset Turnovers stay at 5-year median levels.

To identify potentially attractive investment ideas, The Applied Finance Group (AFG) uses a combination of proprietary variables including valuation, economic performance, management quality, and Earnings Quality. In December of 2008, ValueExpectations.com released a list of companies sorted only by AFG’s Value Score (defined below). Our valuation techniques have proven successful at identifying mispriced securities, which has helped our clients select stocks that outperform their chosen benchmark.

The ValueExpectations.com blog posted in December 2008 (High Value Score Stocks - S&P 500), contained these high Value Score companies (DDS, S, NOV, MTW, SII, WFR, CHK), and outperformed the S&P 500 by 40% as of our 3-26-09 performance update. We recently checked the average performance of those picks through 8-27-2009 to find that they have returned an astounding 52% above the S&P 500, with 6 of the 7 companies outperforming. High Value Score Stocks Part 2, released on 5-7-09 has also outperformed the S&P 500 by nearly 3% since its release, with a batting average of just over 60%.

Due to the success of the first two “High Value Score” blogs, we again used valuation as a basis for selecting a new set of investment ideas. Listed below are the top 10 companies in the S&P 500 (excluding Financials) based on AFG Value Score alone. These companies look the most attractive from a valuation perspective relative to the rest of the index.

AFG's Valuation Metric – Measures the percent to target (deviation between a stock’s current trading price and its AFG current default target price). To derive the intrinsic value of a firm, AFG uses its proprietary Valuation Model (modified discounted cash flow model).

Back in February Valueexpectations.com released a blog highlighting Fidelity’s Low Priced Stock Fund that follows a strategy of only investing in stocks with a share price of under $35. In that blog we provided a list of 30 stocks that we thought were attractively priced according to The Applied Finance Group’s (AFG's) valuation model broken up into three price brackets: under $10, $10 to $20 and $20 to $35.

From Feb 5th 2009 to June 5th 2009 the 30 stocks recommended as a group outperformed the S&P 500 by an average of 36.5%, the 10 stocks under $10 outperformed by 57.1%, the $10 to $20 stocks outperformed by 40.1% and the $20 to $35 stocks outperformed by 12.5% respectedly. 

Joel Tillinghast, the fund’s manager began this fund with a strategy of only investing in stocks under $10. Since this stragtegy began Fidelity has moved the stock price limit to $35 where it currently sits. Tillinghast believes that share price alone is not of importance but the lower priced, smaller-cap universe of stocks experiences the most frequent mispricing’s and also has the least amount of analyst coverage.

As an update to the prior blog on this strategy Valueexpectations.com provided a list of 30 stocks that we believe are attractively priced and do not fit AFG's default sell criteria. Each group is ranked based on valuation attractiveness. AFG's analysis begins and ends with valuation, however along the way there are other key factors AFG considers when looking for buy opportunities: expected Economic Margin improvement, management quality, earnings quality.

Attractively Priced Companies Under $30

Listed below are the companies in the Energy & Extraction sector within the S&P 500 Index, ranked in order of valuation attractiveness. Currently, the Energy & Extraction sector has the highest median Value Score of all sectors according The Applied Finance Group’s April 2009 Monthly Market Review and looks to be trading at a significant discount relative to its historic valuation.

All Energy Companies (S&P 500) Ranked By Valuation Attractiveness

Energy Sector - Relative Valuation Chart

The graph above shows the median percentage upside for the Energy sector relative to the overall market across time. Values greater than 1 indicate the sector is more undervalued than the market, while values less than 1 indicate the opposite. The red line identifies the historical median value to provide a basis to understand valuation levels relative to historic norms. This example illustrates that the median Energy company is undervalued relative to the market currently and has been trading at a significant discount to its historic relative valuation, indicating a potentially attractive opportunity.

By using The Applied Finance Group’s (AFG's) Risk Analysis, we have identified the top and bottom two firms in each sector (excluding the Financial sector) according to an overall risk score based on 9 variables (see more detail below). In addition to the risk analysis variables we also added another layer of analysis by evaluating the companies’ Earnings Quality (based on the concept of Accruals) and Altman Z-Score (identifies firms that are at risk of going bankrupt in the next 2 years).

Applied Finance Group’s Risk Analysis is designed to systematically calculate a stock’s risk score based on fundamental relationships between the Quarterly Income Statements and Balance Sheets. The template measures 9 factors to determine Risk: Changes in A/R, Changes in Inventories, Cash Flow vs. Operating Cash Flow, Fixed Payments vs. Pre-Tax Cash Flow, Leverage, Intangibles, Write-offs, Management Quality, and Valuation. Companies with lower scores have less risk. Companies in the Financial Sector were excluded due to their differences in financial statement structure.
 

1. Receivables to Sales - Delta – takes the difference in the median A/R to Sales ratio over the last 4 quarters vs. median 4 quarters before that.

2. Inventories to Sales - Delta – takes the difference in the median Inventories to Sales ratio over the last 4 quarters vs. median 4 quarters before that.

3. AFG’s Cash Flow-Oper. vs. Operating Cash Flow - AFG's Cash Flow-Oper. for a company is net cash that is generated by the continuing and discontinuing operations of the firm. We compare it to the company's Operating Cash Flow to assess its ability to pay its debt.

4. Fixed Payments vs. Pre-tax Payments Cash Flow – This ratio assesses the company’s ability to cover long-term obligations. If the fixed pmts are greater than 50% of the pre-tax payments cash flow, there is chance that this company may not be able to meet its obligations. Obligations less than 30% of cash flow are considered safe.

5. Leverage – Book leverage and Market leverage are analyzed to give us information about the company’s leverage position. Best score is given to the companies with Book Leverage lower than 60%, and negative score to these with Book Leverage higher than 60% and Market Leverage greater than 0.9*Book Leverage.

6. Intangibles as a Percentage of Total Assets – With this score we try to filter through and reward the companies that have grown organically, rather than through acquisitions. Our research has shown that on average companies tend to overpay for acquisitions and thus are rarely a profitable investment. Companies with Intangibles less than 20% of Total Assets get the best score.

7. Write-offs – Shows the number of years with significant write-offs over the last 5 years.

8. Management Quality – Measures a company’s EM+1 and LFY Asset Growth and there is empirical evidence that companies with positive EMs that are able to grow their business tend to outperform companies with negative EMs who continue to invest into unprofitable business.

9. Value Score – Measures a company’s attractiveness from valuation perspective.

Most/Least Risky Firms By Sector S&P 500 (excluding financials)

If you are a professional investor and would like to learn more about this analysis as well as other useful valuation tools click here for a free trial subscription to The Applied Finance Group's research.

Here are the best and worst performing stocks in the S&P 500 for the month of January excluding financials. Compare the implied sales growth priced-in to justify the current trading price (VE Sales Growth) vs. what the company has delivered in sales growth the past 5 years (5 Year Median Sales Growth) to see if the expectations are realistic for the company to achieve. The more realistic the expectations are compared to what has been delivered the more likely the firm will be to out-perform.

Top 10 stocks in January (excluding financials) and Sales Growth Expectations

Worst 10 stocks in January (excluding financials) and Sales Growth Expectations

According to MotleyFool.com, InvestorPlace.com, Jubak’s Journal, Cramer, and FortuneMagazine.com these are the most attractive stocks to own in 2009. Compare the sales growth priced-in to justify the current stock price (VE Sales Growth) to what the company has achieved in revenue growth over the last five years (5 Year Median Sales Growth) to see if what’s priced-in is a reasonable number for the company to meet or exceed expectations. Couple the expectation information with AFG’s ranking for a stock’s attractiveness relative to the universe (Value Score AFG) to find companies that we find attractive on a default basis that also have low expectations for growing sales compared to what they have delivered the past 5 years. Companies with High Value Score’s and low sales growth expectations will be the companies on this list that are more likely to out-perform.

Recommended Stocks for 2009

Related Article: EPS Increased.....Company Underperformed?

AFG Market Forecast Project
Insights From
Professional Investors
 
The Applied Finance Group would like to invite professional investors to join AFG’s Market Forecast Project so you can better understand what your peers currently think about the market and cultivate the “wisdom of Crowds” into actionable investment ideas and themes. 
Click here to learn more

Nearly all of the biggest return earning companies in the S&P 500 are firms that have been beaten up over the past few months but have bounced back to provide the biggest return in the entire index for the month of December. These firms have ended 2008 on a high note and move into 2009 with what they hope to be sustainable momentum.

The list of companies in the S&P 500 with the worst returns in December had also been trending downward for the past few months but were unable to muster a year-end turnaround as those on the other list had been able accomplish. Many of the firms on this list have something to do with oil, as their stock prices have been highly correlated with the falling price of oil.

Compare the sales growth priced-in to justify the current stock price (VE Sales Growth), to what the company has been able to deliver the past 5 years in revenue growth (5 Year Median Sales Growth), to see which companies have reasonable expectations of achieving the Sales Growth priced-in. Companies with low expectations relative to what they have been able to achieve are more likely to out-perform.

Sales Growth Expectations for the Highest Return Companies (S&P 500) - December

**denotes only 2 years historical sales growth available (2 year median used)

Sales Growth Expectations for the Lowest Return Companies (S&P 500) - December

VE Sales Growth Calculated for these firms on 12/26/08.

Economic Margin (EM) Defined - A measure of corporate performance that captures off balance sheet items, by looking at how much a company is earning above or below their cost of capital. EM is expressed in a % or margin. The Economic Margin Framework™ is more than just a performance metric as it encompasses a valuation system that explicitly addresses the four main drivers of enterprise value: profitability, competition, growth and cost of capital.

Here is a list of companies, two from each sector within the S&P 500 that are expected to improve their Economic Margins (EM) the most over the next two years along with the bottom two in each sector expected to have their EM’s deteriorate the most. Companies expected to improve their EM’s more than their sector peers have proven to be more likely to out-perform. Improving EM’s coupled with low expectations priced-in for sales growth are the companies on this list that may be worth a look as a potential investment.

Also included in this table is the implied sales growth priced-in over the next five years in order to justify the stock’s current trading price compared with their achieved 5 Year Median Sales Growth. Ask the question are the expectations for sales growth realistic compared with what revenue growth the firm has delivered in the last five years.

If you would like to learn more about the Economic Margin methodology or Value Expectations feel free to contact an AFG representative to schedule a web-demo at support@afgltd.com.

S&P 500 Companies with the Biggest Forecasted Change in Economic Margins