Financial Statement Analysis
Financial Statement Analysis
On the basis of the method of operation followed financial statement analysis can be of following
two types:
• Cross sectional analysis.
Balance Sheet
As on 31st December 2004
Assets A Co. B Co. Equity and A Co. B Co.
Liabilities
×= ×=
Sales 22,00,000 21,00,000
100 100% 100 100%
Less: Cost of Goods Sold 22,00,000 21,00,000
×= ×=
11,60,000 12,60,000
100 52.73% 100 60%
22,00,000 2100,000
×= ×=
Gross Margin 10,40,000 8,40,000
×= ×=
Operating Income 2,80,000 1,80,000
100 12.73% 100 8.57%
Less: Interest Expenses 22,00,000 21,00,000
×= ×=
80,000 30,000
100 3.64% 100 1.43%
22,00,000 21,00,000
×= ×=
Net Income Before Tax 2,00,000 1,50,000
100 9.09% 100 7.14%
Less: Income Tax @ 30% 22,00,000 21,00,000
×= ×=
60,000 45,000
100 2.73% 100 2.14%
22,00,000 21,00,000
×= ×=
Net Income 1,40,000 1,05,000
100 6.36% 100 5.00%
22,00,000 21,00,000
×= ×=
Cash 20,000 21,000
100 12.41% 100 13.00%
14,50,000 13,00,000
×= ×=
Accounts Receivable 1,80,000 1,69,000
×= ×=
Current Assets 5,50,000 4,90,000
100 37.93% 100 37.69%
14,50,000 13,00,000
×= ×=
Property and Equipment 9,00,000 8,10,000
100 62.07% 100 62.31%
14,50,000 13,50,000
×= ×=
Total Assets 14,50,000 13,00,000
100 100% 100 100%
14,50,000 13,00,000
×= ×=
Accounts Payable 1,20,000 2,00,000
100 8.28% 100 15.4%
Long-term Bonds 14,50,000 13,00,000
×= ×=
4,80,000 3,00,000
100 33.10% 100 23.08%
14,50,000 13,00,000
×= ×=
Total Liabilities 6,00,000 5,00,000
100 41.38% 100 38.46%
14,50,000 13,00,000
×= ×=
Common Stock 5,00,000 5,05,000
100 34.48% 100 38.46%
Retained Earnings 14,50,000 13,00,000
×= ×=
3,50,000 3,00,000
100 24.14% 100 23.08%
14,50,000 13,00,000
×= ×=
Total Liabilities and Equity 14,50,000 13,00,000
100 100% 100 100%
14,50,000 13,00,000
Problem 2:
From the following information:
i. Prepare a common-size Income Statement and a common-size Balance Sheet for the Company
X and Company Y.
ii. Compare the financial position of the companies in terms of cost of goods sold, net income,
current assets, long-term bonds, and equity.
Income Statement
For the year ended 31st December 2004 & 2005
Company X Company Y
Balance Sheet
As on 31st December 2004 & 2005
Assets Co. X Co. Y Equity and Liabilities Co. X Co. Y
•
Current liabilities
Cash + Marketablesecurities
•
Sales
Cash + Marketablesecurities
•
Total assets
The higher each of these ratios, the higher the cash resources available to the firm.
Liquidity:
Liquidity refers to the ability of a firm to meet its short-term financial obligations when and as they
fall due. The cash position ratios discussed capture one dimension of liquidity. Two additional
liquidity ratios are frequently used are:
·+ +
Quick ratio =
securities accountsreceivable
•
Currenct liabilities
Currenct ratio =·
Currenct assets
•
Currenct liabilities
Both ratios extend the assets in the numerator of the cash position ratios to include items that
potentially can be converted into cash. The quick ratio includes accounts receivable (cash + short
term marketable securities + accounts receivables are often called the “quick assets”). The current
ratio also includes in the numerator items such as inventories and prepaid expenses. The higher
both the ratios, the higher the liquidity position of the firm.
•
Sales
Working capital from operations
•
Total Assets
Capital Structure:
Capital structure ratios provide insight into the extent to which nonequity capital is used to
finance the assets of the firm. Some representative ratios are as follows:
Long term liabilities
−
•
Shareholder s equity
'
Current liabilities long term liabilities
+−
•
Shareholder s equity
'
The higher each of these ratios, the higher the proportion of assets financed by non-shareholder
parties.
Debt Service Coverage:
Debt service coverage refers to the ability of an entity to service from its operations interest
payments that are due to nonequity suppliers of capital. The ratio useful in making inferences about
coverage is:
Operating income
•
Annual erest payments
int
The higher this ratio, the greater the ability to service interest payments to external parties.
Profitability:
Profitability refers to the ability of a firm to generate revenues in excess of expenses. When
making comparisons across firms (or over time), it is useful to control for differences in their
resource base. The following three ratios illustrate alternative ways of expressing relative
profitability: Net income
•
venues
Re
Net income
•
Shareholder s equity
'
Net income
•
Total assets
The net income-to-revenue ratio indicates how much net income is earned from each amount of
revenue. The net income to shareholder’s equity ratio (sometimes shortened to return on equity
ratio) measures the efficiency with which common shareholder’s equity is being employed within
the firm. The net income-to-total assets ratio measures the efficiency with which assets are
employed within the firm. The higher each of these of ratios, the more profitable the firm in a
relative sense.
•
Accounts receivable
As accounts receivable pertain only to credit sales, it is often recommended that the numerator
include only credit sales. In many cases, however, total sales are used due to the breakdown of
cash and credit sales not being provided in published annual reports. By dividing 365 by the
accounts receivable turnover ratio, one obtains an estimate of the average collection period of
credit sales.
A third turnover ratio is the inventory turnover ratio:
Cost of goods sold
•
Inventory
•
Net income available to common
The higher the price-to-earnings ratio, the higher the expected future income relative to the
current reported income.
A second capital market variable frequently used is dividend payout
ratio: Dividends paid
•
Net income
Trend Statements:
Constructing trend statements involves choosing one year as a base and then expressing the
statement items of subsequent years relative to their value in the base year. As a conversion, the
base year is given a value of 100. It refers to the general direction of the data indicating the decrease
or increase during a long period of time.
Problem 3:
You are given the following information of George Company:
George Company
Income Statement
For the year ended 31st December 2001, 2002, 2003, & 2004
2004 2003 2002 2001
George Company
Balance Sheet
As on 31st December 2001, 2002, 2003, & 2004
2004 2003 2002 2001
Assets
Prepare trend statements for the above-mentioned variables considering 2001 as base.
Solution:
George Company
×= ×=
Sales 22,00,000 21,00,000 86.21% 100%
×= ×=
Cost of Goods Sold 11,60,000 12,60,000 92.86% 100%
×= ×=
Operating Expenses 7,60,000 8,40,000 104% 100%
×= ×=
Interest Expenses 28,000 66,000 80% 100%
George Company
Trend Statement for Balance Sheet
2004 2003 2002 2001
Assets
×= ×=
Cash 20,000 21,000 110% 100%
Problem 4:
From the following information of Hindustan Industries Ltd. prepare trend statements for the
above-mentioned variables considering 2000 as base.
Hindustan Industries Ltd.
Income Statement
For the year ended 31st December 2000, 2001, & 2002
2000 2001 2002
Variability Measurement:
An approach that is gaining popularity is to compute variability measures for financial ratios and
other variables over time. One object is to expand beyond one fiscal year the information
contained in a single ratio measure. The formula for measuring variability is as follows:
Variability−
Maximum value Minimum value
=
Mean financialratio
Problem 6:
You are given the following information on the Price Earnings Ratio of AB, CD, EF, and GH Inc.
Company 1999 2000 2001 2002
Which company’s Price Earning’s ratios are highly volatile? [Ans. GH]
• One source is a cash flow analysis for the current and future periods. One benefit of using
this information source is that it focuses directly on the financial distress notion for the
period of interest.
• A second source of information about financial distress is a corporate strategy analysis. This
analysis considers the potential competitors of the firm or institution, its relative cost
structure, plant expansion in the industry, the ability of the firm to pass along cost increases,
the quality of management, and so on.
• A third source of information about financial distress is an analysis of the financial statements
of the firm and those of comparison set of firms. This analysis can focus on a single
financial variable (univariate analysis) or on a combination of financial variables
(multivariate analysis).
• A fourth source of information comes from external variables such as security returns and
bond ratings.
Importance of Financial Distress for Different Parties:
Parties that can utilize the prediction of the financial distress of corporations are discussed below:
• Lenders: Financial distress prediction has relevance to lending institutions, both in deciding
whether to grant a loan (and its conditions) and in deciding policies to monitor existing loans.
• Investors: Distress prediction models can be of assistance to investors in debt securities when
assessing the likelihood of a company experiencing problems in making interest or
principal repayments.
• Regulatory authorities: In certain industries, regulatory bodies have the responsibility of
monitoring the solvency and stability of individual companies.
• Auditors: One judgment auditors must make is whether s firm is a going concern. This
judgment affects the asset and liability valuation methods that are deemed appropriate for
financial reporting.
• Management: If early warning signals of bankruptcy are received, management can arrange
a merger with another firm or adopt a corporate reorganization plan at a more propitious
time.
Edward I. Altman’s Z Score Model:
This multivariate model divides corporations into high or low bankrupt risk classes’ contingent on
their observed characteristics. It was developed by Edward I. Altman for publicly traded
manufacturing firms in the United States. The indicator variable Z is an overall measure of the
bankrupt risk classification of the borrower. That, in turn, depends on the values of various
financial ratios of the corporations and the weighted importance of these ratios based on the past
observed experience of defaulting versus nondefaulting corporations. Altman’s discriminant
function takes the following form for publicly traded companies:
12340 5Z=1.2X +1.4X + 3.3X + 0.6X +1. X
Where, X1 = Working capital/total assets ratio.
X2 = Retained earnings/total assets ratio.
X3 = Earnings before interest and taxes/total assets ratio.
X4 = Market value of equity/book value of total liabilities.
X5 = Sales/total assets ratio.
Altman’s discriminant function takes the following form for non-publicly traded companies:
Altman notes that any publicly traded firm with Z-score below 1.81 is considered to be a prime
candidate for bankruptcy, and the lower the score, the higher the failure probability. On the other
hand, any non-publicly traded firm with Z-score below 1.20 is considered to be a prime candidate
for bankruptcy, and the lower the score, the higher the failure probability
Suppose that the financial ratios of a publicly traded firm took the following values:
X1 = 0.2, X2 = 0, X3 = -2.0, X4 = 0.10, and X5 = 2.0
The Z score for the firm = 1.2×0.2 +1.4×0 + 3.3×(−2.0) + 0.6×0.10 +1.0×2.0
= 1.64.
Thus, the firm is in financial distress according to the multivariate z-score model.
Problem 7:
On the basis of information given in problem 1, you are required to do the following: 1. Find the
value of1 2 3 4 0 5 Z =1.2X +1.4X + 3.3X + 0.6X +1. Xfor A Co. and B Co. Assume the market
value of equity of A Co. and B Co. are Tk.7,50,000 and Tk.10,00,000 respectively. [Ans. For
Co. A, Z = 3.598; and For Co. B, Z = 3.86]
2. Comment on your calculation regarding future financial distresses.