Archive for the ‘Analyze & Interpret A/cs’ Category

Assessing the Company’s Gearing/Borrowing/Leverage Level

Wednesday, October 24th, 2007

This article deals with the business accounting ratio for assessing the LEVERAGE or gearing of a company Essentially, the Leverage Financial ratio should be able to measure the amounts of borrowed money being used by the firm.

Leverage Ratios are classified as either:

  • Capitalization Ratios, focusing on how investments are financed; or
  • Coverage Ratios, focusing on the ability to service the firm’s sources of financing.

Ratio DEBT / LEVERAGE / GEARING RATIO
Formula Total Liabilities
Total Assets
Use Measures the proportion of total assets financed by debt.
Values Lower is safer
Interpretation Total liabilities= short term + long term debt
A low ratio may indicate potential to finance new assets with debt

Ratio DEBT-EQUITY RATIO
Formula Total debt
Total Equity
Use Measures the extent of debt financing to equity.
Values Varies with industry.
<1.1 Strong
<2:1 Acceptable
<3:1 Evidence of weakness
>3:1 Weak
>4:1 Problems present
>6:1 Likely to fail
Interpretation A higher ratio means :-
-Less long term stability
-Higher financial risk
-Lower long term debt capacity
Higher business risk requires lower Debt Equity ratio
Distorted by substantial intangible assets and off-balance sheet liabilities
If too low, may be reducing potential Return on Equity

Ratio NET INTEREST COVER / TIMES INTEREST EARNED
Formula EBIT
Interest
Use Measures the extent of which earnings are available to meet interest payments
Values Varies with industry.
Larger is safer
>3:1 Strong
>2.5:1 Acceptable
>1:1 Evidence of weakness
<1:1 Problems present
Interpretation A lower net interest cover means less earnings are available to meet interest payments and that the business is more vulnerable to increases in interest rates.
Should consider stability and quality of earnings (and cash flow)

Assessing The Company’s Utilisation/Activity Of Assets

Wednesday, October 24th, 2007

The following financial accounting ratio is for the assessing the activity of assets deployed by the company. Essentially, the activity ratios measure the efficiency of managing or using of assets like

  • total assets,
  • accounts receivable,
  • inventory, and
  • accounts payable.

Below demonstrates using the overall/total assets to company’s total sales. However, you can apply the aforesaid individual assets against the company’s total sales to understand which assets have been best or under utilised by the company.

Ratio TOTAL ASSETS TURNOVER
Formula Net Sales
Total Assets (or average) or Accounts Receivable, Inventory
Use Measure the efficiency of the usage of total assets in generating sales.
Values Varies.
The higher is the more effective
Interpretation Comparing similar periods and similar industry statistics determines measures of efficiencies by which the assets are employed in the business.

Assessing the Company’s Profitability

Wednesday, October 24th, 2007

The following financial accounting ratio helps to measure the bottom-line results or the profitability of the company.

Some typical major profitability ratios are:

  • Gross profit & Net profit margin,
  • Return on Total Assets,
  • Return on Equity.

Ratio GROSS PROFIT MARGIN
Formula Gross Profit
Net Sales
Use Indicates profitability of trading and mark-up
Values Varies.
15-25% for supermarkets
#90 % for software industry
20-30% is OK
Interpretation Must be compared to industry averages and the trend over time
High gross margin means a lot of money left over to spend on other business operations such as research & development or marketing.
If GPM is on downwards trends, might be a tell tale sign of future problems facing the bottom line [when labor and material costs increase rapidly, likely to lower gross profit margins-unless company pass these costs to customers in the form of higher selling prices]
The results may skew if the company has a very large range of products
Ratio NET PROFIT MARGIN
Formula Net Profit After Taxes
Net Sales
Use Indicates overall business profitability. Shows how effective managers run the business.
Values Approx 10-20% is good. Higher is better
>8% Strong
>6% Acceptable
<4% Evidence of weakness
<2% Weak
<0% Problems present
Interpretation Comparing gross & net margins, we can get a good sense of its non-production & non-direct costs like administration,finance & marketing costs. E.g. in the software business: exceeding high gross margin of #90% but a net profit margin of 27%. This shows that its marketing & administration costs are very high while its cost of sales & operating costs are relatively low.
High net margin means – bigger cushion to protect themselves during hard times & reflects a competitive advantage to improve market share when things improve again.

Ratio RETURN ON TOTAL ASSETS (ROA)
Formula Net Profit After Taxes
Total Assets
Use Indicates how well assets are used to create wealth, regardless of capital structure. Profitability of operations management
Values Depends on industry
10-15% is reasonable
Interpretation Add back interest expenses back into net income when performing this calculation so as to ignore financing and focuses on operations
Affected by assets valuation and mix
Beware of one-off changes
Can be broken into more useful details – asset turnover & profit margin using a Dupont framework.
Ratio RETURN ON EQUITY (ROE)
Formula Net Profit After Taxes
Shareholders Equity
Use Indicates how well management is employing the investors’ capital invested in the company.
Values A steadily increasing ROE is a hint that management is giving shareholders more for their money which is represented by shareholders’ equity
>30% Strong
>20% Acceptable
<15% Evidence of weakness
<10% Weak
< 5% Problems present
< 0% Likely to fail
Interpretation Offers a useful signal of financial success since it might indicate whether the company is growing profits without pouring new equity capital into the business .
Good companies outperform other investments of similar RISK
Return should be higher for higher business and financial risk.

Assessing The Liquidity Of A Company From Its Financial Statements

Wednesday, October 24th, 2007

Let’s look at the financial ratio for assessing the liquidity of a company. Liquidity means the firm’s ability to satisfy its short-term obligations as they come due.


Two typical ratios are recommended:

  • The Current Ratio, and
  • The Quick (Acid-Test) Ratio.

Tabulated as follows for easy reference:

Ratio          QUICK RATIO or ACID TEST RATIO
Formula
  • Total Current Assets minus Inventory

Total Current Liabilities

Use
  • Measure the ability to pay urgent liabilities, a MORE stringent test to meet short term obligations. Focus on only the most liquid of the firm’s current assets : cash, marketable securities and accounts receivable
Values
  • >1:1  is good as it indicates that if sales revenue disappeared, the business could meet its current obligations with readily available “quick” funds on hand.

  • 1:1 is satisfactory unless the majority of “quick” assets are in accounts receivable & company has a pattern of collecting accounts receivable slower than paying accounts payable
Interpretation
  1. No of times Liquid Current assets is over Current Liabilities
  2. Industry implications
  3. Linked to cash flow cycle
  4. Trend is important
  5. Better working capital management makes ratio fall
  6. Seasonal factors are relevant
  7. Too high indicates poor working capital management
  8. Higher quick ratios are needed when a company has difficulty borrowing on short term notice

Ratio QUICK RATIO or ACID TEST RATIO
Formula
  • Total Current Assets minus Inventory

Total Current Liabilities

Use
  • Measure the ability to pay urgent liabilities, a MORE stringent test to meet short term obligations. Focus on only the most liquid of the firm’s current assets : cash, marketable securities and accounts receivable
Values
  • >1:1  is good as it indicates that if sales revenue disappeared, the business could meet its current obligations with readily available “quick” funds on hand.
  • 1:1 is satisfactory unless the majority of “quick” assets are in accounts receivable & company has a pattern of collecting accounts receivable slower than paying accounts payable
Interpretation
    1. No of times Liquid Current assets is over Current Liabilities
    2. Industry implications
    3. Linked to cash flow cycle
    4. Trend is important
    5. Better working capital management makes ratio fall
    6. Seasonal factors are relevant
    7. Too high indicates poor working capital management
    8. Higher quick ratios are needed when a company has difficulty borrowing on short term notice

Questions Normally Asked On Ratio Analysis

Wednesday, October 24th, 2007

As managers whether with or without financial accounting knowledge, it’s important to understand really what is financial accounting ratio analysis. We need to understand that like any analytical tools, it has benefits and of course certain limitation.

Append below are some frequently/commonly asked questions on Financial Accounting Ratio Analysis:

QUESTION NO 1: WHAT REALLY IS RATIO ANALYSIS?

Ratio analysis involves methods of calculating and interpreting financial ratios to assess a firm’s financial condition and performance.

QUESTION NO 2: WHO IS INTERESTED IN RATIO ANALYSIS?

Since it’s able to assess a firm’s financial condition and performance, hence it is of Interest to all users group.

QUESTION NO 3: HOW MANY TYPES OF RATIO COMPARISONS CAN YOU USE?

Ratio comparisons can be broadly classified into three types:

  1. Trend or Time-Series Analysis
    -To evaluate a firm’s performance over time.
  2. Cross-Sectional Analysis
    -To compare one firm’s financial performance to the industry’s average performance. Cross-sectional analysis is used to compare different firms at the same point in time.
  3. Combined Analysis
    -A combination of both time series analysis and cross-sectional analysis.

QUESTION NO 4: DO YOU KNOW THAT RATIO ANALYSIS HAS CERTAIN LIMITATIONS?

Ratios must be considered together

Financial statements that are being compared should be dated at the same point in time.

Use audited financial statements when possible.

Merely numbers & data hard to get.

Be wary of inflation distortions, historical cost, different accounting policies, management manipulation & different definitions.

It is difficult to define categorically what a good or bad ratio value should be.

QUESTION NO 5: DO YOU KNOW THERE ARE HOW MANY TYPES OF FINANCIAL RATIO CLASSIFICATION?

Broadly classified under:

  • Liquidity
  • Asset Management
  • Profitability
  • Financial leverage management
  • Market-based ratios inclusive of dividend policy
  • Bankruptcy

Common Size Methodolgy To Analyze The Company’s Financial Statements

Wednesday, October 24th, 2007

Using common size methodology to analyze the financial statements like the Income Statement and Balance Sheet are extremely useful as it removes bias particularly when the companies are of differing sizes. Common financial statements enable us to do easy analysis between companies or between time periods of a company. It allows us to analyze the company over various time periods, revealing, for example, what percentage of sales is cost of goods sold and how that value has changed over time or what percentage of total assets is inventory/receivables and how that value has changed over time. So what is really common size financial statements?

Common size methodology is simply displaying or formatting all items whether in the balance sheet or income statement as percentages of a common base figure.

In the case of an income statement, the common base is the revenue whilst in the balance sheet it can be the total assets/total liabilities.

Common size financial statement is one of the principal tools used in ratio analysis as most firms don’t report their statements in common size, it is beneficial to compute if we want to analyze two or more companies of differing size against each other.

Let’s look at a simple Income Statement – a normal one and then compared with a Common size : A normal Income Statement

In Thousand(‘000)

Year 2006

Year 2005

Sales

15,000

11,000

COGS

10,000

8,000

Gross Profit

5,000

3,000

Operating Costs

1.000

1,100

Operating Profit

4,000

1,900

Other Incomes

100

50

Profit Before Tax

4,100

1,950

Translated into a Common Size Income Statement

Line

Year 2006

Year 2005

Year 2006

Year 2005

Revenues

15,000

11,000

100.0%

100.0%

COGS

10,000

8,000

66.7%

72.7%

1

Gross Profit

5,000

3,000

33.3%

27.3%

2

Operating Costs

1.000

1,100

6.6%

10.0%

Operating Profit

4,000

1,900

26.7%

17.3%

3

Other Incomes

600

50

4.0%

0.5%

Profit Before Tax

4,600

1,950

30.7%

17.8%

After the re-format / display into common size income statement, we can see how the various components of the income statement affecting the company’s profit.

Line (1) – gross profit have improved from 27.3% in 2005 to 33.3% - why?

Line (2) - operating costs also improved from 10% to 6.6% - why?

As a result now we know what caused the improvement in operating profit

But what is this “ other incomes” under Line 3 from a meager 0.5% have rose to 4.% of total revenues?

Is it common for this type of company to have such high other income – is it exceptional re: one time affair which might distort the profit before tax.

If we want to delve further, we should go into details into the operating cost (line2) or we can put up a detailed financial statement for inter-companies comparies.

Next what about the common size Balance sheet :

With a common-size balance sheet that displays all items as percentages of a common base figure like total assets, it assist us to perform analysis between companies or between time periods of a company.

Simple Illustration:

A normal Balance Sheet

In Thousand(‘000)

Year 2006

Year 2005

Cash

2,000

1,200

Inventory

3,300

2,000

Receivables

4,,500

2,000

Investments

2,000

1,500

Total Assets

11,800

6,700

Translated into a Common Size Balance Sheet

Line

In Thousand(‘000)

Year 2006

Year 2005

Year 2006

Year 2005

1

Cash

1,000

3,200

8%

48%

2

Inventory

4,300

1,000

36%

15%

3

Receivables

4,500

1,000

39%

15%

4

Investments

2,000

1,500

17%

22%

5

Total Assets

11,800

6,700

100%

100%

The above illustrates the difference between a regular balance sheet and a common size balance sheet.

Salient points:

  • In the normal balance sheet, account values are expressed in dollar terms, while

  • in the common size one, each value is listed as a percentage of total assets.

  • This is also done for liabilities, where each liability account is a percentage of total liabilities

Reviewing the common sized balance sheet, line 1-3 showed a drastic decline of holding cash and more investments into inventory and receivables.

Techniques To Analyze The Company’s Financial Statements

Wednesday, October 24th, 2007

This article deals with some of methods/techniques to analyze the financial statement.

They include the following:

  1. Comparative Financial Statements – Year to year changes

  2. Index Number Trend Series
  3. Specialized Analysis
  4. Common - Size Financial Statements
  5. Ratio Analysis

1. Comparative financial statements -Year to year changes This analysis is very commonly used however there are certain basic rules we  need to understand/avoid: 

Rule No.1:-

  • when a negative amount appears in the base year and a positive amount in the following year or vice versa no percentage change can be meaningfully computed.
     

Rule No.2:-

  • When an item has a value in a base year and none in the following period, the decrease is 100 percent.

Rule No. 3:-

  • Where there is no figure for the base year, no percentage change can be computed.

Simple Illustration:

                                 Year 1      Year 2        $            %

Net income/(loss)    (4,500)      1,500      6,000         -         

Tax expense              2,000      (1,000)   (3,000)        -

Notes payable              -            8,000      8,000         -

Notes receivable      10,000          -        (10,000)    (100)

Next, we move to the second method which is the

Index-Number Trend Series

When a comparison of financial statements covers more than 3 years method no 1- Year to year method of comparison may become too cumbersome.

The best way to effect such longer-term trend comparison is by means of index numbers. The computation of a series of index numbers requires the choice of a base year that will, for all items, have an index amount of 100. since such a base year represents a frame of reference for all comparisons, it is best to choose a year that, in a business condition sense, is as typical or normal as possible. If the earliest year in the series compared cannot fulfils this function , another year is chosen. As is the case with the computation of year-to-year percentages changes, certain changes, such as those from negative to positive amounts, cannot be expressed by means of index numbers. All index numbers are computed by reference to the base year.
In planning an index-number trend comparison, only include the most significant item. 

Care should be exercised in the use of index-number trend comparisons because such comparisons have weaknesses as well as strength.

 For the specialized analysis method, this includes like:- 

  • Cash forecasts
  • Analysis of changes in financial position
  • Statement of variation in gross margin
  • Breakeven analysis

The next article is on Common-Size Financial Statements which will enable readers to properly analysis and interpret financial statements.