Accounts Part-II 4 PDF

Analysis of Financial Statements 4
Y ou have learnt about the financial statements

of companies. Basically, these are summarised
financial reports which provide the operating results
and financial position of companies, and the detailed
information contained therein is useful for assessing
the operational efficiency and financial soundness
of a company. This requires proper analysis and
interpretation of such information for which a
number of techniques (tools) have been developed
by financial experts. In this chapter we will have an
overview of these techniques.
4.1 Meaning of Analysis of Financial Statements

The process of critical evaluation of the financial
LEARNING OBJECTIVES information contained in the financial statements in
After studying this chapter, order to understand and make decisions regarding
you will be able to : the operations of the firm is called ‘Financial
• explain the nature and Statement Analysis’. It is basically a study of
significance of financial relationship among various financial facts and
analysis;
• identify the objectives of
figures as given in a set of financial statements, and
financial analysis; the interpretation thereof to gain an insight into the
• describe the various tools profitability and operational efficiency of the firm to
of financial analysis; assess its financial health and future prospects.
• state the limitations of The term ‘financial analysis’ includes both
financial analysis; ‘analysis and interpretation’. The term analysis
• prepare comparative and
commonsize statements
means simplification of financial data by methodical
and interpret the data classification given in the financial statements.
given therein; and Interpretation means explaining the meaning and
• calculate the trend significance of the data. These two are
percentages and interpret complimentary to each other. Analysis is useless
them.
without interpretation, and interpretation without analysis is difficult or even

impossible.
Box
Financial statement analysis is a judgemental process which aims to estimate
current and past financial positions and the results of the operation of an
enterprise, with primary objective of determining the best possible estimates
and predictions about the future conditions. It essentially involves regrouping
and analysis of information provided by financial statements to establish
relationships and throw light on the points of strengths and weaknesses of a
business enterprise, which can be useful in decision-making involving comparison
with other firms (cross sectional analysis) and with firms’ own performance,
over a time period (time series analysis).
4.2 Significance of Financial Analysis

Financial analysis is the process of identifying the financial strengths and
weaknesses of the firm by properly establishing relationships between the various
items of the balance sheet and the statement of profit and loss. Financial analysis
can be undertaken by management of the firm, or by parties outside the firm,
viz. owners, trade creditors, lenders, investors, labour unions, analysts and
others. The nature of analysis will differ depending on the purpose of the analyst.
A technique frequently used by an analyst need not necessarily serve the purpose
of other analyst because of the difference in the interests of the analysts. Financial
analysis is useful and significant to different users in the following ways:
(a) Finance manager: Financial analysis focusses on the facts and
relationships related to managerial performance, corporate efficiency,
financial strengths and weaknesses and creditworthiness of the company.
A finance manager must be well-equipped with the different tools of
analysis to make rational decisions for the firm. The tools for analysis
help in studying accounting data so as to determine the continuity of the
operating policies, investment value of the business, credit ratings and
testing the efficiency of operations. The techniques are equally important
in the area of financial control, enabling the finance manager to make
constant reviews of the actual financial operations of the firm to analyse
the causes of major deviations, which may help in corrective action
wherever indicated.
(b) Top management: The importance of financial analysis is not limited to
the finance manager alone. Its scope of importance is quite broad which
includes top management in general and other functional managers.
Management of the firm would be interested in every aspect of the financial
178 Accountancy : Company Accounts and Analysis of Financial Statements
analysis. It is their overall responsibility to see that the resources of the

firm are used most efficiently and that the firm’s financial condition is
sound. Financial analysis helps the management in measuring the
success or otherwise of the company’s operations, appraising the
individual’s performance and evaluating the system of internal control.
(c) Trade payables: Trade payables, through an analysis of financial
statements, appraises not only the urgent ability of the company to meet
its obligations, but also judges the probability of its continued ability to
meet all its financial obligations in future. Trade payables are particularly
interested in the firm’s ability to meet their claims over a very short period
of time. Their analysis will, therefore, confine to the evaluation of the
firm’s liquidity position.
(d) Lenders: Suppliers of long-term debt are concerned with the firm’s long-
term solvency and survival. They analyse the firm’s profitability overtime,
its ability to generate cash to be able to pay interest and repay the principal
and the relationship between various sources of funds (capital structure
relationships). Long-term tenders do analyse the historical financial
statements. But they place more emphasis on the firm’s projected financial
statements to make analysis about its future solvency and profitability.
(e) Investors: Investors, who have invested their money in the firm’s shares,
are interested about the firm’s earnings. As such, they concentrate on
the analysis of the firm’s present and future profitability. They are also
interested in the firm’s capital structure to ascertain its influences on
firm’s earning and risk. They also evaluate the efficiency of the
management and determine whether a change is needed or not. However,
in some large companies, the shareholders’ interest is limited to decide
whether to buy, sell or hold the shares.
(f) Labour unions: Labour unions analyse the financial statements to assess
whether it can presently afford a wage increase and whether it can absorb
a wage increase through increased productivity or by raising the prices.
(g) Others: The economists, researchers, etc. analyse the financial statements
to study the present business and economic conditions. The government
agencies need it for price regulations, taxation and other similar purposes.
4.3 Objectives of Financial Analysis

Analysis of financial statements reveals important facts concerning managerial
performance and the efficiency of the firm. Broadly speaking, the objectives of
the analysis are to apprehend the information contained in financial statements
with a view to know the weaknesses and strengths of the firm and to make a
forecast about the future prospects of the firm thereby, enabling the analysts to
take decisions regarding the operation of, and further investment in the firm. To
be more specific, the analysis is undertaken to serve the following purposes
(objectives):
• to assess the current profitability and operational efficiency of the firm
as a whole as well as its different departments so as to judge the financial
health of the firm.
• to ascertain the relative importance of different components of the
financial position of the firm.
• to identify the reasons for change in the profitability/financial position
of the firm.
• to judge the ability of the firm to repay its debt and assessing the
short-term as well as the long-term liquidity position of the firm.
Through the analysis of financial statements of various firms, an economist can
judge the extent of concentration of economic power and pitfalls in the financial
policies pursued. The analysis also provides the basis for many governmental
actions relating to licensing, controls, fixing of prices, ceiling on profits, dividend
freeze, tax subsidy and other concessions to the corporate sector.
4.4 Tools of Financial Analysis

The most commonly used techniques of financial analysis are as follows:
1. Comparative Statements: These are the statements showing the
profitability and financial position of a firm for different periods of time in
a comparative form to give an idea about the position of two or more periods.
It usually applies to the two important financial statements, namely,
Balance Sheet and Statement of Profit and Loss prepared in a comparative
form. The financial data will be comparative only when same accounting
principles are used in preparing these statements. If this is not the case,
the deviation in the use of accounting principles should be mentioned as
a footnote. Comparative figures indicate the trend and direction of financial
position and operating results. This analysis is also known as ‘horizontal
analysis’.
2. Common Size Statements: These are the statements which indicate the
relationship of different items of a financial statement with some common
item by expressing each item as a percentage of that common item. The
percentage thus calculated can be easily compared with the results of
corresponding percentages of the previous year or of some other firms, as
the numbers are brought to common base. Such statements also allow an
analyst to compare the operating and financing characteristics of two
companies of different sizes in the same industry. Thus, common-size
statements are useful, both, in intra-firm comparisons over different years

and also in making inter-firm comparisons for the same year or for several
years. This analysis is also known as ‘Vertical analysis’.
3. Trend Analysis: It is a technique of studying the operational results and
financial position over a series of years. Using the previous years’ data of a
business enterprise, trend analysis can be done to observe the percentage
changes over time in the selected data. The trend percentage is the
percentage relationship, which each item of different years bear to the
same item in the base year. Trend analysis is important because, with its
long run view, it may point to basic changes in the nature of the business.
By looking at a trend in a particular ratio, one may find whether the ratio
is falling, rising or remaining relatively constant. From this observation, a
problem is detected or the sign of good or poor management is detected.
4. Ratio Analysis: It describes the significant relationship which exists
between various items of a balance sheet and a profit and loss account of
a firm. As a technique of financial analysis, accounting ratios measure the
comparative significance of the individual items of the income and position
statements. It is possible to assess the profitability, solvency and efficiency
of an enterprise through the technique of ratio analysis.
5. Cash Flow Analysis: It refers to the analysis of actual movement of cash
into and out of an organisation. The flow of cash into the business is called
as cash inflow or positive cash flow and the flow of cash out of the firm is
called as cash outflow or a negative cash flow. The difference between the
inflow and outflow of cash is the net cash flow. Cash flow statement is
prepared to project the manner in which the cash has been received and
has been utilised during an accounting year as it shows the sources of
cash receipts and also the purposes for which payments are made. Thus,
it summarises the causes for the changes in cash position of a business
enterprise between dates of two balance sheets.
In this chapter, we shall have a brief idea about the first three techniques,
viz. comparative statements common size statements and trend analysis. The
ratio analysis and cash flow analysis is covered in detail in chapters 5 and 6
respectively.
Test your Understanding – I
Fill in the blanks with appropriate word(s),

1. Analysis simply means—————data.
2. Interpretation means —————data.
3. Comparative analysis is also known as ———————— analysis.
4. Common size analysis is also known as ———————— analysis.
5. The analysis of actual movement of money inflow and outflow in an
organisation is called——————— analysis.
4.5 Comparative Statements

As stated earlier, these statements refer to the statement of profit and loss and
the balance sheet prepared by providing columns for the figures for both the
current year as well as for the previous year and for the changes during the
year, both in absolute and relative terms. As a result, it is possible to find out
not only the balances of accounts as on different dates and summaries of different
operational activities of different periods, but also the extent of their increase or
decrease between these dates. The figures in the comparative statements can be
used for identifying the direction of changes and also the trends in different
indicators of performance of an organisation.
The following steps may be followed to prepare the comparative statements:
Step 1 : List out absolute figures in rupees relating to two points of time (as
shown in columns 2 and 3 of Figure 4.1).
Step 2 : Find out change in absolute figures by subtracting the first year (Col.2)
from the second year (Col.3) and indicate the change as increase (+) or decrease
(–) and put it in column 4.
Step 3 : Preferably, also calculate the percentage change as follows and put it
in Column 5.
Second year absolute figure (Col.3)

____________________________________________________________
× 100
First year absolute figure (Col.2)
Particulars First Year Second Year Absolute Percentage

Increase (+) or Increase (+)
Decrease (–) or Decrease (–)
1 2 3 4 5
Rs. Rs. Rs. %.
Fig. 4.1
Illustration 1
Convert the following statement of profit and loss into the comparative statement
of profit and loss of BCR Co. Ltd.:
Particulars Note 31 March 31 March
No. 2013 2014
(i) Revenue from operations 60,00,000 75,00,000
(ii) Other incomes 1,20,000 1,50,000
(iii) Expenses 50,60,000 44,00,000
(iv) Income tax 40% 35%
Solution:
Comparative statement of profit and loss for the year ended March 31, 2013
and 2014:
Particulars 2014 2013 Absolute Percentage
Decrease (-) or Decrease (-)
Rs. Rs. Rs. Rs.
I. Revenue from operations 75,00,000 60,00,000 15,00,000 25.00
II. Add: Other incomes 1,20,000 1,50,000 (30,000) (20.00)
III. Total Revenue I+II 76,20,00 61,50,000 14,70,000 23.90
IV Less: Expenses 50,60,000 44,00,000 6,60,000 15.00
Profit before tax 25,60,000 17,50,000 8,10,000 46.29
V Less: Tax 10,24,000 6,12,500 4,11,500 67.18
Profit after tax 15,36,000 11,37,500 3,98,500 35.03
Illustration 2
From the following statement of profit and loss of Madhu Co. Ltd., prepare
comparative statement of profit and loss for the year ended March 31, 2013 and
2014:
Particulars Note 31 March 31 March
No. 2013 2014
Rs. Rs.
Revenue from operations 16,00,000 20,00,000
Employee benefit expenses 8,00,000 10,00,000
Other expenses 2,00,000 1,00,000
Tax rate 40 %
Solution:
Comparative statement of profit and loss of Madhu Co. Ltd., for the year ended
March 31, 2013 and 2014:
Rs. Rs. Rs. %
I. Revenue from operations 20,00,000 16,00,000 4,00,000 25
II. Less: Expenses
a) Employee benefit expenses 10,00,000 8,00,000 2,00,000 25
b) Other expenses 1,00,000 2,00,000 (1,00,000) (50)
Profit before tax 9,00,000 6,00,000 3,00,000 50
III. Less tax @ 40% 3,60,000 2,40,000 1,20,000 50
Profit after tax 5,40,000 3,60,000 1,80,000 50
Do it yourself
From the following particulars, prepare comparative statement of profit and loss of Narang
Colors Ltd. for the year ended March 31, 2013 and 2014:
Particulars Note 2014 2013
No.
1. Revenue from operations 40,00,000 35,00,000
2. Other income 50,000 50,000
3. Cost of material consumed 15,00,000 18,00,000
4. Changes in inventories of finished goods 10,000 (15,000)
5. Employee benefit expenses 2,40,000 2,40,000
6. Depreciation and amortisation 25,000 22,500
7. Other expenses 2,66,000 3,02,000
8. Profit 20,09,000 14.27,300
Notes to Accounts
Particulars 2014 2013
1. Other expenses
i) Power and fuel 36,000 40,000
ii) Carriage outwards 7,500 9,500
iii) License fees 2,500 2,500
iv) Selling and distribution 1,70,000 1,90,000
v) Provision of tax 50,000 60,000
2,66,000 3,02,000
Illustration 3
The following are the excerpts of balance sheets of J. Ltd. for the year ended
March 31, 2013 and 2014. Prepare a Comparative balance sheet and comment
on the financial position of the business firm.
No. (Rs.) (Rs.)
I. Equity and Liabilities
1. Shareholders’ Funds
a) Share capital 20,00,000 15,00,000
b) Reserve and surplus 3,00,000 4,00,000
2. Non-current Liabilities
a) Long-term borrowings 9,00,000 6,00,000
3. Current liabilities
a) Trade payables 3,00,000 2,00,000
Total 35,00,000 27,00,000
II. Assets
1. Non-current assets
a) Fixed assets
- Tangible assets 20,00,000 15,00,000
- Intangible assets 9,00,000 6,00,000
b) Current assets
- Inventories 3,00,000 4,00,000
- Cash and cash equivalents 3,00,000 2,00,000
2. Current assets
Total 35,00,000 27,00,000
Solution:
Comparative balance sheet of J. Ltd. as at March 2013 and March 2014:
(Figure in Lakhs)
Change Change
a) Share capital 20 15 05 33.33
b) Reserve and surplus 03 04 01 (25)
a) Long-term borrowings 09 06 03 50
a) Trade payables 03 02 01 50
Total 35 27 08 29.63
II. Assets
a) Fixed assets
- Tangible assets 20 15 05 33.33
- Intangible assets 09 06 03 50
b) Current assets
- Inventories 03 04 (01) (25)
- Cash and cash equivalents 03 02 01 50
Total 35 27 08 29.63
Illustration 4
From the following balance sheets of Amrit Ltd., as on March 31, 2013 and
2014, prepare a comparative balance sheet:
No. (Rs.) (Rs.)
a) Share capital 20,00,000 15,00,000
Total 35,00,000 27,00,000
II. Assets
a) Fixed assets
- Tangible assets 20,00,000 15,00,000
b) Current assets
- Inventories 3,00,000 4,00,000
2. Current assets
Total 35,00,000 27,00,000
Solution:
Comparative Balance Sheet of Star Ltd.
as at March 31st, 2013 and March 31st , 2014
Rs. in Lakhs
Rs. Rs. Rs. Rs.
1) Shareholders’ funds
a) Share capital 20 15 5 33.33
b) Reserves and surplus 3 4 (1) (25)
2) Non-current liabilities
Long-term borrowings 9 6 3 50
3) Current liabilities
Trade payables 3 2 1 50
Total 35 27 8 29.6
II. Assets
1) Non-current assets
Fixed assets
a) Tangible assets 20 15 5 33.33
b) Intangible assets 9 6 3 50
2) Current assets
a) Inventories 3 4 (1) (25)
b) Cash and cash equivalents 3 2 1 50
Total 35 27 8 29.6
Do it yourself
From the Balance Sheets for the year ended March 31, 2013 and 2014, prepare the
comparative Balance Sheet of Omega Chemicals Ltd.:
Rs. in Lakhs
No. (Rs.) (Rs.)
1) Shareholder’s Fund
a) Share capital 5 10
b) Reserves and surplus 3 2
2) Non-current liabilities
a) Long-term borrowings 5 8
3) Current liabilities
Trade Payable 2 4
Total 15 24
II. Assets
1) Non-current assets
a) Fixed assets
- Tangible assets 14 8
- Intangible assets 3 2
2) Current assets
a) Inventories 5 4
b) Cash and cash equivalents 2 1
Total 24 15
4.6 Common Size Statement

Common Size Statement, also known as component percentage statement, is a
financial tool for studying the key changes and trends in the financial position
and operational result of a company. Here, each item in the statement is stated
as a percentage of the aggregate, of which that item is a part. For example, a
common size balance sheet shows the percentage of each asset to the total assets,
and that of each liability to the total liabilities. Similarly, in the common size
income statement, the items of expenditure are shown as a percentage of the net
sales. If such a statement is prepared for successive periods, it shows the changes
of the respective percentages over time.
Common size analysis is of immense use for comparing enterprises which
differ substantially in size as it provides an insight into the structure of financial
statements. Inter-firm comparison or comparison of the company’s position
with the related industry as a whole is possible with the help of common size
statement analysis.
The following procedure may be adopted for preparing the common size
statements.
1. List out absolute figures in rupees at two points of time, say year 1,
and year 2 (Column 2 & 4 of figure 4.2).
2. Choose a common base (as 100). For example, Sales revenue total
may be taken as base (100) in case of income statement, and total
assets or total liabilities (100) in case of balance sheet.
3. For all items of Col. 2 and 4 work out the percentage of that total.
Column 3 and 5 shows these percentages in Figure 4.2.
Common Size Statement
Particulars Year Year Percentage Percentage
one two of year 1 of year 2
1 2 3 4 5
Figure 4.2
Illustration 5
From the following information, prepare a Common-size Statement of profit and
loss for the year ended March 31, 2013 and 2014:
Particulars March 31, 2013 March 31, 2014

Rs. Rs.
Net sales 18,00,000 25,00,000
Cost of good sold 10,00,000 12,00,000
Operating expenses 80,000 1,20,000
Non-operating expenses 12,000 15,000
Depreciation** 20,000 40,000
Wages 10,000 20,000
Solution:
Common-Size income statement for the year ended March 31, 2013 and March
31, 2014:
Particulars absolute Amounts Percentage of Net Sales
31.03.2014 31.03.2013 31.03.2014 31.03.2013
(%) (%)
Net Sales 25,00,000 18,00,000 100 100
(Less) Cost of goods 12,00,000 10,00,000 48 55.56
Sold
Gross Profit 13,00,000 8,00,000 52 44.44
(Less) Operating 1,20,000 80,000 4.80 4.44
Expenses
Operating Income 11,80,000 72,20,000 47.20 40
(Less) Non-Operating 15,000 12,000 0.60 0.67
expenses
Profit 11,65,000 7,08,000 46.60 39.33
* Wages is the part of cost of goods sold;

** Depreciation is the part of operating expenses.
Illustration 6
From the following information, prepare common-size statement of profit and
loss for the year ended March 31, 2013 and March 31, 2014:
Particulars March, 2014 March, 2013
Rs. Rs.
Revenue from operations 25,00,000 20,00,000
Other income 3,25,000 2,50,000
Employee benefit expenses 8,25,000 4,50,000

Other expenses 2,00,000 1,00,000
Income tax (% of the profit before tax) 30% 20%
Solution:
Common-size statement of profit and loss for the year ended March 31, 2013
and March 31, 2014:
Particulars absolute Amounts Percentage of Net Sales
31.03.2014 31.03.2013 31.03.2014 31.03.2013
(%) (%) (%) (%)
Revenue from Operations 25,00,000 20,00,000 100 100
(Add) Other income 3,25,000 2,50,000 13 12.5
Total revenue 28,25,000 22,50,000 113 112.5
(Less) expenses:
a) Employee benefit 8,25,000 4,50,000 33 22.5
expenses
b) Other expenses 2,00,000 1,00,000 8 5
Profit before tax 18,00,000 17,00,000 72 85
(Less) taxes 5,40,000 3,40,000 21.6 17
Profit after tax 12,60,000 13,60,000 50.4 68
Illustration 7
Prepare common-size balance sheet of XRI Ltd. from the following information:
Particulars Note No. March 31 March 31
2014 2013
1. Shareholder’s Fund
a) Share capital 15,00,000 12,00,000
b) Reserves and surplus 5,00,000 5,00,000
2. Non-current liabilities
a) Trade Payable 15,50,000 10,50,000
Total 32,50,000 32,50,000
II. Assets
a) Fixed assets
- Tangible asset
Plant & machinery 15,00,000 10,00,000
- Intangible assets
Goodwill 15,00,000 10,00,000
b) Non-current investments 10,00,000 10,00,000
2. Current assets
a) Inventories 1,50,000 2,50,000
Total 32,50,000 32,50,000
Solution:
Common-size statement of profit and loss for the year ended March 31st , 2013
and March 31st , 2014:
Particulars Absolute Amounts Percentage of Net Sales

31.03.2014 31.03.2013 31.03.2014 31.03.2013
(%) (%)
1. Shareholders fund
a) Share capital 15,00,000 12,00,000 36.14 36.93
b) Reserve and surplus 5,00,000 5,00,000 12.05 15.38
a) Long-term borrowings 6,00,000 5,00,000 14.46 15.38
a) Trade payables 15,50,000 10,50,000 37.35 32.31
Total 41,50,000 32,50,000 100 100
II. Assets
a) Fixed assets
- Tangible asset
Plant & machinery 14,00,000 8,00,000 33.73 24.61
- Intangible assets
Goodwill 16,00,000 12,00,000 38.55 36.92
2. Non-current investments 10,00,000 10,00,000 24.10 30.77
a) Current assets
- Inventories 1,50,000 2,50,000 3.62 7.69
Total 41,50,000 32,50,000 100 100
Do it yourself
Prepare common-size balance sheet of Raj Co. Ltd. as at March 31, 2013 and
March 31, 2014 from the given information:

1. Shareholders fund
a) Share capital 20,00,000 15,00,000
Total 35,00,000 27,00,000
II. Assets
a) Fixed assets
- Tangible assets 20,00,000 15,00,000
b) Current assets
- Inventories 3,00,000 4,00,000
Total 35,00,000 27,00,000
Test your Understanding – II
Choose the right answer :

1. The financial statements of a business enterprise include:
(a) Balance sheet
(b) Profit and loss account
(c) Cash flow statement
(d) All the above
2. The most commonly used tools for financial analysis are:
(a) Horizontal analysis
(b) Vertical analysis
(c) Ratio analysis
(d) All the above
3. An Annual Report is issued by a company to its:
(a) Directors
(b) Auditors
(c) Shareholders
(d) Management
4. Balance Sheet provides information about financial position of the enterprise:
(a) At a point in time
(b) Over a period of time
(c) For a period of time
(d) None of the above
5. Comparative statement are also known as:
(a) Dynamic analysis
(b) Horizontal analysis
(c) Vertical analysis
(d) External analysis
4.7 Trend Analysis

The financial statements may be analysed by computing trends of series of
information. Trend analysis determines the direction upwards or downwards
and involves the computation of the percentage relationship that each item bears
to the same item in the base year. In case of comparative statement, an item is
compared with itself in the previous year to know whether it has increased or
decreased or remained constant. Common size is observed to know whether the
proportion of an item (say cost of goods sold) is increasing or decreasing in the
common base (say sales). But in case of trend analysis, we learn about the
behaviour of the same item over a given period, say, during the last 5 years.
Take for example, administrative expenses, whether they are exhibiting
increasing tendency or decreasing tendency or remaining constant over the period
of comparison, generally trend analysis is done for a reasonably long period.
Many companies present their financial data for a period of 5 or 10 years in
various forms in their annual reports.
4.7.1 Pr ocedur
Procedur
oceduree for Calculating T
Trr end Per centage
Percentage
One year is taken as the base year. Generally, the first year is taken as the base
year. The figure of base year is taken as 100. The trend percentages are calculated
in relation to this base year. If a figure in other year is less than the figure in base
year, the trend percentage will be less than 100 and it will be more than 100 if
figure is more than the base year figure. Each year’s figure is divided by the
base year figure.
Present year value
Trend Percentage = ____________________________________ ´ 100
Base year value
The accounting procedures and conventions used for collecting data and
preparation of financial statements should be similar; otherwise the figures will
not be comparable.
Illustration 7
Calculate the trend percentages from the following figures of sales, stock and
profit of X Ltd., taking 2010 as the base year and interpret them.
(Rs. in lakhs)
Year Sales Stock Profit
(Rs.) (Rs.) before tax
(Rs.)
2010 1,881 709 321
2011 2,340 781 435
2012 2,655 816 458
2013 3,021 944 527
2014 3,768 1,154 627
Solution:
Trend Percentages (base year 2010 = 100)
(Rs. in lakhs)
Year Sales Trend % Stock Trend % Profit Trend %
Rs. Rs. Rs.
2010 1881 100 709 100 321 100
2011 2340 124 781 110 435 136
2012 2655 141 816 115 458 143
2013 3021 161 944 133 527 164
2014 3768 200 1154 163 627 195
Interpretation :
1. The sales have continuously increased in all the years up to 2014, though in
different proportions. The percentage in 2014 is 200 as compared to 100 in
2010. The increase in sales is quite satisfactory.
2. The figures of stock have also increased over a period of five years. The increase
in stock is more in 2013 and 2014 as compared to earlier years.
3. Profit has substantially increased. The profits have increased in greater
proportion than sales which implies that the company has been able to reduce
their cost of goods sold and control the operating expenses.
Do it Yourself
Yourself
The following data is available from the Statement of profit and loss of Deepak Ltd.
Particulars 2010 (Rs.) 2011 (Rs.) 2012 (Rs.) 2013 (Rs.)
Sales 3,10,000 3,27,500 3,20,000 3,32,500
Wages 1,07,500 1,07,500 1,15,000 1,20,000
Selling Expenses 27,250 29,000 29,750 27,750
Gross Profit 90,000 95,000 77,500 80,000
You are required to show Trend Percentages of different items.
Illustration 8
From the following data relating to the assets side of Balance Sheet of ABC Ltd.,
for the period ended March 31, 2011 to March 31, 2014, calculate trend
percentages.
(Rs. in Lakhs)
Particulars 2011 2012 2013 2014
Cash 100 120 80 140
Debtors 200 250 325 400
Stock 300 400 350 500
Other current assets 50 75 125 150
Land 400 500 500 500
Buildings 800 1000 1200 1500
Plant 1000 1000 1200 1500
Solution:
Trend Percentages
(Rs. in lakhs)
Assets 2011 Trend 2012 Trend 2013 Trend 2014 Trend
% % % %
Current Assets
Cash 100 100 120 120 80 80 140 140
Debtors 200 100 250 125 325 162.5 400 200
Stock 300 100 400 133.33 350 116.67 500 166.67
Other Current Assets 50 100 75 150 125 250 150 300
650 100 845 130 880 135.38 1,190 183.08
Fixed Assets
Land 400 100 500 125 500 125 500 125
Buildings 800 100 1,000 125 1,200 150 1,500 187.5
Plant 1000 100 1,000 100 1,200 120 1,500 150
2,200 100 2,500 113.64 2,900 131.82 3,500 159.00
Total Assets 2,850 100 3,345 117.36 3,780 132.63 4,690 164.56
Interpretation:
1. The assets have exhibited a continuous increasing trend over the period.
2. The current assets increased much faster than the fixed assets.
3. Sundry debtors and other current assets and buildings have shown higher growth.
Illustration 9
From the following data relating to the liabilities side of balance sheet of X Ltd.,
for the period March 31, 2010 to 2013, calculate the trend percentages taking
2010 as the base year.
(Rs. in lakhs)
Liabilities 2010 2011 2012 2013
Equity Share Capital 1,000 1,000 1,200 1,500
General Reserve 800 1,000 1,200 1,500
12% Debentures 400 500 500 500
Bank Overdraft 300 400 550 500
Bills Payable 100 120 80 140
Sundry Creditors 300 400 500 600
Outstanding Liabilities 50 75 125 150
Solution:
Trend Percentages
(Rs. in Lakhs)
Liabilities 2010 Trend 2011 Trend 2012 Trend 2013 Trend
% % % %
Shareholder Funds
Equity Share Capital 1,000 100 1,000 100 1200 120 1,500 150
General Reserve 800 100 1,000 125 1200 150 1,500 187.5
1,800 100 2,000 111.11 2400 133.33 3,000 166.67
Long-term Debts
Debentures 400 100 500 125 500 125 500 125
400 100 500 125 500 125 500 125
Current Liabilities
Bank Overdraft 300 100 400 133.33 550 183.33 500 166.67
Bills Payable 100 100 120 120 80 80 140 140
Sundry Creditors 300 100 400 133.33 500 166.67 600 200
Outstanding Expenses 50 100 75 150 125 250 150 300
750 100 995 132.67 1,255 167.33 1,390 185.33
Total (Liabilities) 2,950 100 3,495 118.47 4,155 140.85 4,890 165.76
Interpretation:
1. Shareholders’ funds have increased over the period because of retention of profits
in the business in the form of reserves, and the share capital has also increased,
may be due to issue of fresh shares or bonus shares.
2. The increase in current liabilities is more than that of long-term debt. This may
be due to expansion of business and/or availability of greater credit activities.
Test your Understanding – III

State whether each of the following is True or False :
(a) The financial statements of a business enterprise include cash flow statement.
(b) Comparative statements are the form of horizontal analysis.
(c) Common size statements and financial ratios are the two tools employed in
vertical analysis.
(d) Ratio analysis establishes relationship between two financial statements.
(e) Ratio analysis is a tool for analysing the financial statements of any enterprise.
(f) Financial analysis is used only by the creditors.
(g) Statement of profit and loss account shows the operating performance of an
enterprise for a period of time.
(h) Financial analysis helps an analyst to arrive at a decision.
(i) Cash Flow Statement is a tool of financial statement analysis.
(j) In a Common size statement each item is expressed as a percentage of some
common base.
4.8 Limitations of Financial Analysis

Though financial analysis is quite helpful in determining financial strengths
and weaknesses of a firm, it is based on the information available in financial
statements. As such, the financial analysis also suffers from various limitations
of financial statements. Hence, the analyst must be conscious of the impact of
price level changes, window dressing of financial statements, changes in
accounting policies of a firm, accounting concepts and conventions, personal
judgement, etc. Some other limitations of financial analysis are:
1. Financial analysis does not consider price level changes.
2. Financial analysis may be misleading without the knowledge of the
changes in accounting procedure followed by a firm.
3. Financial analysis is just a study of reports of the company.
4. Monetary information alone is considered in financial analysis while
non-monetary aspects are ignored.
5. The financial statements are prepared on the basis of on-going concept,

as such, it does not reflect the current position.
T er ms Intr
erms oduced in the Chapter
Introduced
1. Financial Analysis 2. Common Size Statements

3. Comparative Statements 4. Trend Analysis
5. Ratio Analysis 6. Cash Flow Analysis
7. Intra Firm Comparison 8. Inter Firm Comparison
9. Horizontal Analysis 10. Vertical Analysis
Summary
Major Parts of an Annual Report

An annual report contains basic financial statements, viz. Balance Sheet, Profit
and Loss Account and Cash Flow Statement. It also carries management’s
discussion of corporate performance of the year under review and peeps into the
future prospects.
Tools of Financial Analysis

Commonly used tools of financial analysis are: Comparative statements, Common
size statement, trend analysis, ratio analysis, funds flow analysis and cash flow
analysis.
Comparative Statement
Comparative statement captures changes in all items of financial statements in
absolute and percentage terms over a period of time for a firm or between two
firms.
Common Size Statement

Common size statement expresses all items of a financial statement as a percentage
of some common base such as revenue from operations for statement of profit and
loss and total assets for balance sheet.
Ratio Analysis
Ratio analysis is a tool of financial analysis which involves the methods of
calculating and interpreting financial ratios in order to assess the strengths and
weaknesses in the performance of a business enterprise.
Question for Practice
Short Answer Questions

1. List the techniques of Financial Statement Analysis.
2. Distinguish between Vertical and Horizontal Analysis of financial data.
3. State the meaning of Analysis and Interpretation.
4. State the importance of Financial Analysis?
5. What are Comparative Financial Statements?
6. What do you mean by Common Size Statements?
Long Answer Questions

1. Describe the different techniques of financial analysis and explain the
limitations of financial analysis.
2. Explain the usefulness of trend percentages in interpretation of financial
performance of a company.
3. What is the importance of comparative statements? Illustrate your
answer with particular reference to comparative income statement.
4. What do you understand by analysis and interpretation of financial
statements? Discuss its importance.
5. Explain how common size statements are prepared giving an example.
Numerical Questions
1. Following are the balance sheets of Alpha Ltd. as at March 31st, 2013
and 2014:
Rs. Rs.
Equity share capital 2,00,000 4,00,000
Reserves and surplus 1,00,000 1,50,000
Long-term borrowings 2,00,000 3,00,000
Short-term borrowings 50,000 70,000
Trade payables 30,000 60,000
Short-term provisions 20,000 10,000
Other current liabilities 20,000 30,000
Total 6,20,000 10,20,000
II. Assets
Fixed assets 2,00,000 5,00,000
Non-current investments 1,00,000 1,25,000
Current investments 60,000 80,000
Inventories 1,35,000 1,55,000

Trade receivables 60,000 90,000
Short term loans and advances 40,000 60,000
Cash at bank 25,000 10,000
Total 6,20,000 10,20,000
You are required to prepare a Comparative balance sheet.
2. Following are the balance sheets of Beta Ltd. at March 31st, 2013 and
2014:
(Rs.) (Rs.)
Equity share capital 4,00,000 3,00,000
Reserves and surplus 1,50,000 1,00,000
Loan from IDBI 3,00,000 1,00,000
Short-term borrowings 70,000 50,000
Trade payables 60,000 30,000
Short-term provisions 10,000 20,000
Other current liabilities 1,10,000 1,00,000
Total 11,00,000 7,00,000
II. Assets
Fixed assets 4,00,000 2,20,000
Non-current investments 2,25,000 1,00,000
Current investments 80,000 60,000
Stock 1,05,000 90,000
Trade receivables 90,000 60,000
Short-term loans and advances 1,00,000 85,000
Cash and cash equivalents 1,00,000 85,000
Total 11,00,000 7,00,000
3. Prepare Comparative Income Statement from the following information:

Particulars 2014 (Rs.) 2013 (Rs.)
Freight Outward 20,000 10,000
Wages (office) 10,000 5,000
Manufacturing Expenses 50,000 20,000
Stock adjustment (60,000) 30,000

Cash purchases 80,000 60,000
Credit purchases 60,000 20,000
Returns inward 8,000 4,000
Gross profit (30,000) 90,000
Carriage outward 20,000 10,000
Machinery 3,00,000 2,00,000
Charge 10% depreciation on 10,000 5,000
machinery
Interest on short-term loans 20,000 20,000
10% debentures 20,000 10,000
Profit on sale of furniture 20,000 10,000
Loss on sale of office car 90,000 60,000
Tax rate 40% 50%
4. Prepare Comparative Income Statement from the following information:

Manufacturing expenses 35,000 80,000
Opening stock 30,000 60% of closing stock
Sales 9,60,000 4,50,000
Returns outward 4,000 (out of credit 6,000 (out of cash
purchase) purchase)
Closing stock 150% of opening 1,00,000
stock
Credit purchases 1,50,000 150% of cash purchase
Cash purchases 80% of credit 40,000
purchases
Carriage outward 10,000 30,000
Building 1,00,000 2,00,000
Depreciation on building 20% 10%
Interest on bank overdraft 5,000 -
10% debentures 2,00,000 20,00,000
Profit on sale of copyright 10,000 20,000
Loss on sale of personal car 10,000 20,000
Other operating expenses 20,000 10,000
Tax rate 50% 40%
5. Prepare a Common-size income statement of Shefali Ltd. with the help of

following information:
Sales 6,00,000 8,00,000
Gross profit 50% of sales 45% of sales
Indirect expense 25% of gross profit 25% of gross profit
Less: Cost of goods sold 4,28,000 7,28,000
Other incomes 10,000 12,000
Income tax 30% 30%
6. Prepare a Common Size balance sheet from the following balance sheet
of Aditya Ltd. and Anjali Ltd.:
Particulars Aditya Ltd. Anjali Ltd.
Rs. Rs.
a) Equity share capital 6,00,000 8,00,000
b) Reserves and surplus 3,00,000 2,50,000
c) Current liabilities 1,00,000 1,50,000
Total 10,00,000 12,00,000
II. Assets
a) Fixed assets 4,00,000 7,00,000
b) Current assets 6,00,000 5,00,000
Total 1,00,0000 12,00,000
Answers to Test your Understanding
Test your Understanding – I

1. Simplification 2. explaining 3. the impact of horizontal
4. vertical 5. cash flow.
Test your Understanding – II
1 (d) 2 (d) 3 (c) 4 (a) 5 (b)
Test your Understanding – III
(a) True (b) True (c) True (d) True (e) True (f) False
(g) True (h) True (i) True (j) True

Accounts Part-II 4 PDF

Uploaded by

Copyright:

Available Formats

Accounts Part-II 4 PDF

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Accounts Part-II 4 PDF

Uploaded by

Copyright:

Available Formats

Analysis of Financial Statements 4

Y ou have learnt about the financial statements

4.1 Meaning of Analysis of Financial Statements

without interpretation, and interpretation without analysis is difficult or even

4.2 Significance of Financial Analysis

analysis. It is their overall responsibility to see that the resources of the

4.3 Objectives of Financial Analysis

4.4 Tools of Financial Analysis

statements are useful, both, in intra-firm comparisons over different years

Test your Understanding – I

Fill in the blanks with appropriate word(s),

4.5 Comparative Statements

Second year absolute figure (Col.3)

Particulars First Year Second Year Absolute Percentage

4.6 Common Size Statement

Particulars March 31, 2013 March 31, 2014

* Wages is the part of cost of goods sold;

Employee benefit expenses 8,25,000 4,50,000

Particulars Absolute Amounts Percentage of Net Sales

Particulars 2014 2013

Test your Understanding – II

Choose the right answer :

4.7 Trend Analysis

1,800 100 2,000 111.11 2400 133.33 3,000 166.67

Debentures 400 100 500 125 500 125 500 125

400 100 500 125 500 125 500 125

Bills Payable 100 100 120 120 80 80 140 140

Outstanding Expenses 50 100 75 150 125 250 150 300

750 100 995 132.67 1,255 167.33 1,390 185.33

Test your Understanding – III

4.8 Limitations of Financial Analysis

5. The financial statements are prepared on the basis of on-going concept,

1. Financial Analysis 2. Common Size Statements

Major Parts of an Annual Report

Tools of Financial Analysis

Common Size Statement

Question for Practice

Short Answer Questions

Long Answer Questions

Inventories 1,35,000 1,55,000

3. Prepare Comparative Income Statement from the following information:

Stock adjustment (60,000) 30,000

4. Prepare Comparative Income Statement from the following information:

5. Prepare a Common-size income statement of Shefali Ltd. with the help of

Answers to Test your Understanding

Test your Understanding – I

You might also like