Finacial Statement Analysis Ratio Analysis
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