Finacial Statement Analysis Ratio Analysis
Finacial Statement Analysis Ratio Analysis
LEARNING OBJECTIVES :
      To identify the users of financial statement and information relevant for their
       decision making.
 To understand the meaning and importance of income statement and balance sheet .
Key Words: Financial statement, income statement, net profit, return on equity, cash
flow, ratio analysis.
Introduction
                                              1
Definition of Financial Statement
Statements prepared at the end of a certain accounting period for representing operating
performance and financial position of an institution based on incurred transactions are
financial statement. The process of measuring associations among financial statement
items in order to appraise a firm’s financial situation and operating performance is called
financial statement analysis. This analysis is repeatedly performed by individuals outside
the firm to help them in making credit and investment decisions. However, management
also brings into play financial statement analysis internally so that it can learn the
financial strength and weaknesses of the firm.
Income Statement
The income statement is one of the three major financial statements. The other two are
the balance sheet and the statement of cash flows. It measures the company’s sales and
expenses over a specific period of time. Statement reports the results of operations of an
institution at the end of a particular period of time. It is also called income statement or
profit and loss account.
                                             2
Sales
It is the gross amount of goods sold or services rendered during an accounting period. It
may be recognized at different stages depending on a company. While some recognize
sales upon cash receipt, other do so upon placement of order by customers.
Net Sales
When sales discount, sales returns and allowances to customers are deducted or
subtracted from gross sales the result is net sales.
Gross Profit
Goods are normally sold at a price that is more than the cost price. Gross profit or gross
margin is what remains after cost of goods sold is deducted from net sales. This is the
margin that is available to cove the other expenses for a period and to yield net income, if
there is any.
Operating Expenses
Merchandising or trading concerns incur operating expenses in addition to cost of goods
sold. So, the expenses which are incurred for the generation of revenues from the sales of
goods are called operating expenses. Operating expenses may be divided into two :
selling expenses and administrative expenses.
                                               3
Selling Expenses : All expenses regarding sale of goods and sending them to the buyer
belong to this class e.g. Carriage outwards, advertisements, salesmen's salaries, sales
commission, traveling expenses, bad debts, packaging expenses etc.
Administrative Expenses : All expenses connected with the office and its conduct are
called administrative expenses. Examples of administrative expenses include office
salaries, office rent, electric charges, postage and telegrams, telephones, printing and
stationary etc.
Net Income
Net Income is arrived at by deducting cost of goods sold, operating expenses, interests
and taxes.
                                            4
                                    Income Statement
                        For the Year Ended December 31, 200Y (1,000)
         Sales                                                       $ 1005000
                 Cost of Goods Sold                                    (405000)
Balance Sheet
The balance sheet reports the financial position i.e., amount of equity, liability and assets
of an institution at a particular time point at the end of the certain time period. It is a
statement of the financial position of a business which states the assets, liabilities, and
owners' equity at a particular point of time. In other words, the balance sheet
demonstrates the net worth of the business. The balance sheets provides a clear picture of
the financial condition of the company as a whole.
Assets
Assets include anything that the company actually owns and has disposal over. Examples
of assets of a company are cash, lands, buildings, and real estates, equipment, machinery,
furniture, patents and trademarks, and money owed by certain individuals or/and other
businesses to the particular company. Assets may be any of the following types :
                                             5
      Current Assets : It includes anything that company can quickly convert into
     cash. Such current assets include cash, government securities, marketable securities,
     accounts receivable, notes receivable (other than from officers or employees),
     inventories, prepaid expenses, and any other item that could be converted into cash
     within one year in the normal course of business.
      Fixed Assets : They are long-term investments of the company, such as land,
     plant, equipment, machinery, leasehold improvements, furniture, fixtures, and any
     other items with an expected useful business life usually measured in a number of
     years or decades. Fixed assets are usually accounted as expenses upon their
     purchase.
      Other Assets include any intangible assets, such as patents, copyrights, other
     intellectual property, royalties, exclusive contracts, and notes receivable from
     officers and employees.
Liabilities
Liabilities are money or goods acquired from individuals, and/or other corporate entities.
Example of liabilities would be loans, services to the company on credit, etc.
Shareholder's equity
                                             6
The shareholder’s equity is the capital portion of the business where money or other
forms of assets that are invested into the business by the owner to acquire assets and to
start the business. Any net profits that are not paid out in form of dividends to the owner
are also added to the shareholder’s equity. Losses during the operation of the business are
subtracted from the shareholder’s equity. Equity is calculated the following way:
Cash                                                                     $ 340,000
Accounts receivable                                                        215,000
Inventories                                                                157,050
Prepaid expenses                                                            50,370
Plant and equipment                                                         350,738
Intangible assets                                                           488,600
Total assets                                                              $1,601,758
Liabilities
Statement of Cash-Flow
                                             7
The statement that shows the amount of cash receipts and amount of cash payments from
different sources and activities and for different purposes and areas is known as cash flow
statement. It is important to any business because it can be used to assess the timing,
amount and predictability of future cash flows and it can be the basis for budgeting. The
statement of cash flows therefore, reports cash receipts, cash payments, and net change in
cash resulting from operating, investing, and financing activities of an enterprise during a
period.
          Cash outflows
                 To suppliers for inventory.
                 To government for taxes.
                 To lenders for interest.
                 To others for expenses
It shows the amount of cash firms spent on investments. Investments are usually
classified as either capital expenditures--money spent on items such as new equipment or
anything else needed to keep the business running--or monetary investments such as the
purchase or sale of money market funds.
INVESTING
                                                 8
       (Generally, the following information obtained from Balance Sheet)
       Cash inflows
               From sale of property, plant, and equipment.
               From sale of debt or equity securities of other entities.
               From collection of principal on loans to other entities.
       Cash outflows
               To purchase property, plant, and equipment.
               To purchase debt or equity securities of other entities.
               To make loans to other entities.
It includes any activities involved in transactions with the company's owners or debtors.
For example, cash proceeds from new debt, or dividends paid to investors would be
found in this section.
FINANCING
(Generally, the following information obtained from Balance Sheet)
       Cash inflows
               From sale of equity securities.
               From issuance of debt (bonds and notes).
       Cash outflows
               To stockholders as dividends.
Ratio Analysis
                                                  9
The financial statement analysis in which the numerical relationship between two
financial figures of a financial statement is determined is called ratio analysis. Ratio
analysis is a form of financial statement analysis that is used to obtain a quick indication
of a firm's financial performance in several key areas. It is a tool used by individuals to
conduct a quantitative analysis of information in a company's financial statements. Ratios
are calculated from current year numbers and are then compared to previous years, other
companies, the industry, or even the economy to judge the performance of the company.
There are many ratios that can be calculated from the financial statements pertaining to a
company's performance, activity, financing and liquidity.
                                             10
There are six aspects of operating performance and financial condition we can evaluate
from financial ratios :
      Short-term debt.
      Accounts payable.
                                             11
      Accrued liabilities.
  By definition, each current asset and liability has a maturity (the expected
date of conversion to cash for an asset; the expected date of liquidation for
cash for liability) of less than one year. However, in practice the line between
current and non-current has blurred in recent years. Marketable securities
and debt are particularly susceptible to arbitrary classification. For this
reason working capital ratios should be used with caution.
      Current ratio.
      Quick ratio.
      Cash ratio.
      Cash flow from operations ratio.
Current Ratio:
        Current ratios are used to judge a firm’s ability to meet short-term obligations. It
indicates the amount of cash available at the balance sheet date plus the amount of
current assets that the firm expects to turn into cash within one year of the balance sheet
date relative to obligations that will be due during of that period.
         The higher the current ratio the greater the ability of the firm to pay its bills.
However, the higher current ratio may also indicate excessive amount of current assets
which is considered to be management’s failure to utilize the resources properly.
Conversely, the lower current ratio may be an indication of failure to payoff the current
liabilities and at the same time may be an indication of possibility of bankruptcy and
failure of management. The traditional or theoretical threshold for this ratio is 2:1.
                          Current Asset
Current Ratio =
                        Current Liabilities
   This ratio is not same as the current ratio. It provides more penetrating
measure of liquidity and it excludes inventory from cash resources
recognizing that the conversion of inventory to cash is less certain both in
terms of timing and the amount. The included assets are quick assets
because they can be quickly converted into cash. In this regard we exclude
                                                 12
inventories from the current assets for measuring the quick ratio.         The
theoretical threshold is 1:1.
Cash Ratio:
Efficiency Ratios
      Efficiency ratios are used to measure how efficiently the firm uses its
resources to generate sales. Efficiency or activity ratios are used to
evaluating the efficiency, with which the firm manages and utilizes its assets.
These ratios are also called the turnover ratios because they indicate the
speed with which the assets are converted or turnover into sales. A proper
                                               13
balance between assets and sales generally reflects that the assets are
managed well.
      Various aspects of the efficiency with which assets are utilized can be
gleaned from turnover ratios as well as from other ratios.
                                              Annual Sales
Accounts Receivable Turnover Ratio =
                                         Accounts Receivables
This ratio determines how rapidly the firm’s credit accounts are being
collected.
                                    Accounts Receivable
   Average Collection Period    =                            X 365
                                        Annual Sales
                                          Or,
                                        365
                       =
                               Accounts Receivable Turnover
                                         14
Inventory Turnover
                                         Sales
Accounts Payable Turnover =
                                   Accounts Payable
                                 Sales
Total Asset Turnover =
                              Total Assets
                                             15
Fixed Asset Turnover
       Fixed asset turnover ratio indicates how efficiently the firm is using its
fixed asset to generate sales.
                               Sales
Fixed Asset Turnover =
                           Fixed Assets
       Operating asset turnover ratio indicates how efficiently the firm uses
its operating assets in generating sales.
                                            Sales
Operating Asset Turnover =
                             Total Asset – Cash – Short Term Bank Loan
     Debt Ratio.
     Long Term Debt to Total Capitalization.
     Time Interest Earned Ratio.
     Financial Leverage Ratio.
     Debt – Equity Ratio.
Debt Ratio
This ratio indicates how much of the firm’s assets have been financed by
borrowing.
                     Total Liabilities
Debt Ratio =
                      Total Assets
                                         16
Long Term Debt Ratio
      This ratio indicates the percentage of long term debt in the capital
structure of the firm. Higher the ratio means higher the proportion of long
term debt in the capital structure.
    This ratio indicates the firm’s ability to meet its interest payment out of
its annual operating earnings i.e. firm’s ability to pay the financial expenses
that can be visualized through this ratio.
                                     EBIT
Time Interest Earned Ratio =
                                  Annual Interest Expense
Leverage Ratio :
This ratio indicates to what extent asset has been financed by equity.
                                       Total Asset
Financial Leverage Ratio =
                                        Equity
   This ratio indicates the amount of debt generated against each amount of
equity margin contributed by the firm’s owner. Higher debt equity means
lower the internal source of fund available to meet the Long Term Debt.
                                            17
Profitability Ratio :
       This Ratio covers some ratios that show the company’s profitability in
relation to sales or investment. It is the indicator of the firm’s operational
efficiency. Those ratios are analyzed below.
                             Gross Profit
Gross Profit Margin =
                             Annual Sales
                                  EBIT
Operating Profit Margin =
                                  Sales
                            Net Profit
Net Profit Margin =
                                            18
                            Sales
Return on Assets
                            Net Income
Return on Assets =
                            Total Assets
Return on Equity
       This ratio indicates the degree to which the firm is able to convert
operating income into an after tax income that eventually can be claimed by
the shareholders. This is a useful ratio for analyzing the ability of the firm’s
management to realize an adequate return on capital invested by the owner
of the firm.
                            Net Income
       Return on Equity =
                            Total Equity
   This ratio has been determined by dividing dividend with no. of equity
shares.
                                           19
                                                       Amount of Dividend declared
Dividend Per Share (DPS)        =
                                                      No. of equity shares outstanding
                                               DPS
Dividend Payout Ratio       =
                                               EPS
Problem – 1
                                                 20
Debentures                        420000        Sundry Debtors        60000
Sundry Creditors                   50000        Accounts Receivable   50000
Bills Payable                      50000        Cash at Bank          60000
Other Information :
Calculate :
     i)     Current Ratio
     ii)    Quick Ratio
     iii)   Accounts Receivable Turnover Ratio
     iv)    Current assets to fixed asset ratio
     v)     Debt-Equity Ratio
     vi)    Fixed Asset Turnover Ratio
Solution :
i)                                 Current Asset
             Current Ratio =
                                 Current Liabilities
                                     250000
                           =
                                     100000
= 2.50 : 1
                                       250000 - 80000
                           =
                                            100000
= 1.7 : 1
                                              21
iii)                                                      Credit Sales
Accounts Receivable Turnover Ratio =
                                                       Accounts Receivable
                                                           700000
                                     =
                                                            50000
= 14 Times
                                                         250000
                                              =
                                                         600000
= 0.42 : 1
                                      420000
                          =
                                      330000
                          =        1.27 : 1
vi)
                                                        Sales Revenue
      Fixed Asset Turnover Ratio              =
                                                         Fixed Assets
                                                         1000000
                                              =
                                                         600000
= 1.66 : 1
                                                  22
Problem – 2
Common Stock ($l00 per share)             800000     Land & Building           600000
Reserve & Surplus                         200000     Plant & Machinery         500000
10% Preferred Stock                       400000     Inventory                 400000
12% Debentures                            200000     Prepaid Expenses          50000
Accounts Payable                          200000     Accounts Receivable       200000
Bank Overdraft                            150000     Cash at Bank              100000
Outstanding Liabilities                    50000     Marketable Securities     150000
Other Information :
1) Gross Profit Margin is $ 500000 which is 25% of Sales, 2) 80% on credit sale, 3)
operating expense is $ 150000 & Tax rate is 20%. 4) Market price per share is $ 250 and
dividend declared $ 10800.
Calculate :
  i)      Current Ratio.
  ii)     Quick Ratio.
  iii)    Accounts Receivable Turnover Ratio.
  iv)     Inventory Turnover ratio.
  v)      Operating Profit Margin.
  vi)     Net Profit Margin.
  vii)    Return on Asset.
  viii)   Return on Equity.
  ix)     Time Interest Earned Ratio.
  x)      Earning per share.
  xi)     Dividend per share.
  xii)    Dividend payout ratio.
  xiii)   Price Earnings Ratio.
                                           23
Solution :
      Gross Margin is 25% of Sales, Therefore
                                   Gross Profit
      Gross Profit Margin =
                                      Sales
                                     500000
 Or                25%        =
                                      Sales
                                     500000
 Or              Sales    =
                                      0.25
= 2000000
                                              24
i)                            Current Asset
          Current Ratio =
                             Current Liabilities
                                 800000
                       =
                                 400000
= 2 :1
                                    800000 - 300000
                       =
                                       400000
= 1.25 : 1
                                                    1600000
                                =
                                                      200000
= 8 Times
                                                    1500000
                                =
                                                      300000
= 5 Times
                                         25
v)                                       EBIT
      Operating Profit Margin =
                                         Sales
                                         350000
                             =
                                         2000000
= 17.5%
                                              260800
                             =
                                              2000000
= 13.04%
                                              260800
                             =
                                              2000000
= 13.04%
                                              220800
                             =
                                              1000000
= 22.08%
                                                 26
ix)                                            EBIT
  Time Interest Earned Ratio =
                                                 Interest
                                               350000
                             =
                                                24000
= 14.58 Times
                                               220800
                             =
                                                8000
= 27.6
                                                10800
                             =
                                                8000
= 1.35
xii)                                              DPS
        Dividend Payout Ratio     =
                                                  EPS
                                                1.35
                             =
                                                27.6
= 0.0489
                                                 27
xiii)                                        Market Price
        Price Earning Ratio       =
                                                EPS
                                              250
                              =
                                             27.6
= 9.06
Reference Books
    1) Khan, M. Y. & Jain P. K., “Financial Management”, Tata McGraw Hill
          Publishing Co., New Delhi.
7) Weston, J. F. & Brigham, E. F., Managerial Finance, New Delhi ; Prentice Hall.
                                              28
29