Chapter 6. Fundamental Analysis

Table of Contents

1. General Information
1.1. Introduction
1.2. Current Fiscal Year and Fiscal Year
1.3. Using the Notepad
2. Company Accounts
2.1. Description of the company financial data screen
2.2. Year-by-year account presentation
2.3. Sectors of activity
2.4. Price target and potential variation
2.5. Recommendation
2.6. Average Sector P/E
2.7. Beta factor
2.8. Company Discount
2.9. Net Debt
2.10. Net asset per share
2.11. Enterprise Value / Revenue
3. Ratios Chart
3.1. General Information
3.2. Description of the ratios chart
3.3. Chart Types
3.4. Nature of calculated ratios
3.5. Chart Scales
3.6. Additional information available on charts
4. Financial Ratios Table
4.1. Description
4.2. Sorting and ranking according to ratio values

1. General Information

1.1. Introduction

In the general menu, select the Fundamental Analysis tab.

The purpose of fundamental analysis is to analyze a company's accounts over several years in order to assess the relevance of its strategy through the resulting performance, as well as its positioning relative to its competitors. Fundamental analysis is a complement to technical analysis for medium to long-term investment purposes.

Financial data are either downloaded or entered directly by the user into the software from information available on the Internet.

Functions performed by Axial Finance:

  1. Memorization of the essential financial data from operating accounts and balance sheets.

  2. Display of this financial data company by company and calculation of the financial ratios useful for assessing performance.

  3. Graphical display of the financial ratios for lists of companies.

  4. Display in a table of the financial ratios for companies within a market segment or the same industry, allowing for ranking ratio by ratio.

Company accounts are memorized for at least 7 fiscal years: the last four years, the current year, and the next two years.

1.2. Current Fiscal Year and Fiscal Year

The current fiscal year is defined either:

  1. automatically with the downloaded financial data,

  2. by the user using the two navigation buttons present at the bottom of the company-by-company account display screen.

The closing month of the accounts (a number from 1 to 12) is present and modifiable in the company-by-company account display screen.

Axial Finance has adopted the convention that any accounting year closing on or before June 30 is assigned to the previous fiscal year. Thus, a company's accounting year ending on June 30, 2002, will be assigned to fiscal year 2001. Conversely, accounts closing on July 31, 2002, will be assigned to fiscal year 2002.

The user can decide at any time the value of the fiscal year that should correspond to the current year using one of the two buttons below:

Go to next

Generally, for years closing on December 31, the definitive accounts from the previous year are not known before spring. Consequently, for better accuracy of the financial ratios presented in the graphical summary, it is more useful to retain the previous year as the current fiscal year for a few more months. It is advisable to wait for the publication of accounts or to have credible forecasts for the new fiscal year before changing the current year.

Return to the previous

In certain specific cases, it may be necessary to go back for the current fiscal year.

1.3. Using the Notepad

For each company, Axial Finance provides a notepad (2000 character maximum) to allow the user to record any information deemed useful.

The user can enter information obtained from the Internet using the copy/paste function.

2. Company Accounts

2.1. Description of the company financial data screen

The selection of a company is made from the software's stock list. The Financial Data screen detailing a company's accounts, shown below, comprises three main parts:

  1. The top banner with:

    • the company name

    • the Last price and date

    • the Number of shares for the current fiscal year

    • the market Capitalization and the ratio of capitalization (capitalization/revenue) for the current fiscal year

    • the company's Sector of activity

    • the account closing Month

    • the fundamental analysis price target with the potential variation in % compared to the current price

    • the Recommendation according to fundamental analysis

    • the value of the Beta

    • the date of the company's account update

  2. The main central zone displaying the detail of accounts over 7 fiscal years:

    • the four previous fiscal years (columns with a white background)

    • the current fiscal year (column with a light yellow background)

    • the next two fiscal years (columns with a light blue background)

  3. The bottom part with:

    • a button for direct access to the fundamental analysis chapter of the user manual

    • the notepad for the selected company

2.2. Year-by-year account presentation

For each year, the table presents basic data (which can potentially be modified by the user) and data calculated from the former:

  1. the Revenue

  2. the % growth of revenue between two fiscal years

  3. the Operating result

  4. the % of Revenue, i.e., the percentage of operating result over revenue

  5. the Net income

  6. the % of Revenue, i.e., the percentage of net income over revenue

  7. the Earnings Per Share (EPS)

  8. the % growth of earnings per share between two fiscal years

  9. the P/E, i.e., the "Price-Earnings Ratio"

  10. the average Sector P/E

  11. the Net dividend

  12. the Yield, i.e., the division of net dividend by the last price

  13. the Equity

  14. the Net debt

  15. the Net asset per share (for the last three fiscal years)

  16. the ratio (in %) of Net income to Equity

  17. the ratio (in %) of Net debt to Equity

  18. the ratio Enterprise Value to Revenue (for the last three fiscal years)

  19. the ratio Last price to Net asset per share (for the last three fiscal years) with specific red marking if this ratio is less than 1, signifying a company discount

2.3. Sectors of activity

For fundamental analysis, Axial Finance performs a specific classification of companies into approximately fifty sectors. These sectors have been refined compared to classic classifications so that comparisons of instruments within the same sector are as consistent as possible.

2.4. Price target and potential variation

The horizon for this target is 12 to 18 months. The calculation of this target is based on the Whitbeck and Kisor model, which has been adapted for the fundamental analysis module. This target is followed by the percentage of achievable progression relative to the stock price at the date of the recommendation.

2.5. Recommendation

Several criteria are taken into account to determine the recommendation decision.

In particular:

  1. P/E lower or higher than the average P/E of the industry sector

  2. Net income/Revenue higher or not compared to the sector

  3. Net income/Equity higher or not compared to the sector

  4. Revenue growth higher or not compared to the sector

  5. Yield higher or not compared to the sector

  6. EPS growth higher or not compared to the sector

  7. Ratio Enterprise Value/Operating result higher or not compared to the sector

  8. Bonus granted to the instrument in case of a discount relative to its equity

Three types of recommendations are issued for the instruments actually selected:

Buy

The instrument meets all criteria of the fundamental analysis module and possesses a potential appreciation between 10 and 15%, relative to the price at the date of the recommendation

Strong Buy

The instrument meets all criteria of the fundamental analysis module and possesses a potential appreciation greater than 15%, relative to the price at the date of the recommendation

Avoid or Sell

The instrument does not meet the criteria or has no potential for appreciation

2.6. Average Sector P/E

The Average Sector P/E includes most companies in the sector (all segments combined), and not only the SRD stocks of that sector.

2.7. Beta factor

The beta determines the sensitivity of a stock's price relative to the benchmark index. The beta is characterized by the ratio between the covariance of the stock's profitability with that of the benchmark index (CAC 40), and the variance of the benchmark index's profitability.

The beta is a risk indicator:

  • A stock with a beta close to 1 will fluctuate with the index.

  • In the event of an index decline, a stock with a beta lower than 1 is likely to decline less than the index (if the index falls by 1%, a stock with a beta of 0.75 is likely to fall by 0.75%).

  • A beta can be negative: in this case, any rise in the index is likely to imply a decline in the stock's price (and vice versa).

2.8.  Company Discount

When the ratio Price/Net asset per share is less than 1, the stock is considered discounted. In this case, for the current fiscal year, this ratio is displayed in bold white characters on a red background.

2.9. Net Debt

The net debt is equal to the difference between financial debts (short-term and long-term) and cash plus financial investments.

2.10. Net asset per share

The Net asset per share is equal to equity divided by the number of shares.

2.11. Enterprise Value / Revenue

The enterprise value (EV) is the sum of market capitalization and net debt. The ratio EV/Revenue (like the P/E) is an indicator of the stock's cheapness.

3. Ratios Chart

3.1. General Information

From the financial data recorded in the software, Axial Finance establishes several types of charts for companies in a list of stocks, allowing for the assessment of the main ratios used in fundamental analysis.

Nine ratios are thus represented:

  • Market capitalization/Revenue

  • Price-Earnings Ratio (P/E)

  • Earnings Per Share (EPS)

  • Profitability (Net income/Revenue)

  • EPS Variation between the current fiscal year and the next projected fiscal year

  • Last price/Net asset per share

  • Enterprise Value/Revenue

  • Net income/Equity

  • Net debt/Equity

3.2. Description of the ratios chart

The screen shown below comprises:

  1. at the top, the selection zone for the chart display mode, with from left to right:

    • the drop-down list for selecting the list of companies to display

    • the drop-down list for selecting the chart type: as vertical bars, as X,Y points, or as bars and curves

    • the drop-down list for selecting the financial ratio on the left vertical axis

    • the drop-down list for selecting the financial ratio, on the horizontal axis or on the right vertical axis depending on the chart type

    • the button to trigger the print preview

    • the button to display useful information for this screen

  2. in the center, the chart with the chosen ratios

3.3. Chart Types

Three types of ratio chart are available:

  1. Type 1: A chart with vertical bars to represent a single ratio. The companies in the selected list are distributed along the horizontal axis (see example above).

  2. Type 2: A chart with X,Y points to simultaneously represent two different ratios. The companies in the selected list are dots.

  3. Type 3: A mixed chart with vertical bars and a curve to represent two different ratios. The companies in the selected list are distributed along the horizontal axis. The left vertical axis corresponds to the first ratio and the right vertical axis to the second ratio.

The choice of chart type as well as the choice of ratios on the axes are made using the drop-down lists located at the top and center of the screen:

  • The drop-down list in red characters defines the ratio to be displayed on the left vertical axis

  • The drop-down list in blue characters, activated only for types 2 and 3, defines the ratio to be displayed:

    • on the horizontal axis in the case of type 2

    • on the right vertical axis in the case of type 3

3.4. Nature of calculated ratios

Each ratio is calculated as follows:

Market capitalization/Revenue

(Last price)*(Number of shares for the current fiscal year)/(Revenue of the current fiscal year)

P/E

P/E of the current fiscal year = Last price / Earnings Per Share of the current fiscal year

EPS

Earnings per share after adjustments in euros for the current fiscal year

Profitability

Net income attributable to the group of the current fiscal year over Revenue of the current fiscal year

EPS Evolution

% variation of Earnings Per Share from the next fiscal year compared to the Earnings Per Share of the current fiscal year

Price/Net asset per share

Last price over Net book value per share of the current fiscal year

Enterprise Value/Revenue

Current enterprise value (i.e.: current market capitalization plus net debt of the current fiscal year) over Revenue of the current fiscal year

Net Income/Equity

Net income attributable to the group of the current fiscal year over Equity of the previous fiscal year

Net Debt/Equity

Net debt of the current fiscal year over Equity of the previous fiscal year)

Note

For stocks quoted in USD or GBP, the exchange rate used for presenting Earnings Per Share in Euros is the one set in the Portfolio Management module.

3.5. Chart Scales

Axial Finance automatically determines the scales on the axes based on the magnitude of the ratios. However, the user can also fix the scales according to their own needs via the following procedure:

  1. Position the mouse over the horizontal or vertical axis. The cursor arrow changes into a hand.

  2. Double-click with the left mouse button to open the dialog window shown here.

  3. Select the tab for the axis scale you wish to modify.

  4. Uncheck the Automatic Scale box.

  5. Define the maximum graduation of the axis.

  6. Define the minimum graduation of the axis.

  7. Choose the number of graduations between the two extreme values using the drop-down list.

  8. Click the OK button to return to the chart, or click the Apply button to modify another axis scale afterwards.

To return to an automatic scale, check the corresponding box for the axis again.

3.6. Additional information available on charts

3.6.1. Verification of the last stock price

By holding down the left mouse button on a bar in the chart (for types 1 and 3) or on an X,Y point (for type 2), a yellow box appears indicating the last recorded price and date. This information allows for verifying the stock price actually used for the calculation of the ratios.

3.6.2. Specific charts of type 2

In the case of type 2 charts, when the first ratio selected is Market capitalization/Revenue and the second ratio is P/E, a Constant Profitability label is added to the chart to indicate that the lines starting from the origin are loci of constant profitability. A scale of profitability percentages is displayed at the top and right of the chart. By holding down the left mouse button on any part of the chart, you obtain the trace of the constant profitability line reaching that point with the precise indication of the profitability percentage (see example below).

Conversely, when the first ratio selected is Market capitalization/Revenue and the second ratio is profitability, a Constant P/E label is added to the chart to indicate that the lines starting from the origin are loci of constant P/E. A scale providing P/E values is displayed at the top and right of the chart.

4. Financial Ratios Table

4.1. Description

The Financial Ratios table presents the situation of a list of companies according to the seven financial ratios defined above.

This table indicates for each company:

  • The ratio Market capitalization/Revenue .

  • The Price-Earnings Ratio (P/E).

  • The ratio Operating result/Revenue in %.

  • The ratio of profitability, Net income/Revenue in %.

  • The ratio Last price/Net asset per share.

  • The ratio Net income/Equity in %.

  • The ratio Net debt/Equity in %.

  • The ratio Enterprise Value/Revenue.

When the numerator and denominator of the ratio to be calculated are zero, the field for the ratio in the table remains empty. When only the denominator of the ratio is zero, the field for the ratio in the table indicates the infinity symbol.

4.2.  Sorting and ranking according to ratio values

Initially, companies are ranked in the table in alphabetical order.

To rank the companies in the table based on the relative importance of one of the seven ratios :

  1. Choose from the table the column for the ratio by which the ranking should be performed.

  2. Click once on the column header: The ranking of companies is performed in ascending order of the ratio.

  3. Click a second time on the header: The ranking is performed in reverse order (and so on with each new click).