After studying this chapter, you will be able to understand
Meaning Of Financial Statement Analysis
Types Of Financial Statement Analysis
Process Of Financial Analysis
Purposes And Significance Of Financial Analysis
Tools Of Financial Analysis
Comparative Financial Statements
Common Size Statements
Trend Percentage – Features, Method Of Analysis And Limitations
Users Of Financial Statements
Limitations Of Financial Statement Analysis
Financial Statements Of A Company – Types And Formats
As already said, the end product of the accounting process is the preparation of Financial Statements, viz., Profit and Loss Account and Balance Sheet. These are prepared periodically to assess the results achieved by an entity during the specific accounting period. The Income Statement depicts the net result of operations during the period where as the Balance Sheet reflects the financial position of an entity in particular. These statements communicate accounting information to its users both internal and external. The internal users are the management and the important external users are investors, creditors, suppliers, customers, lenders, employees and government and its various agencies. But mere presentation of figures in these statements would not be enough. Users of these financial statements are darely in need of more specific information relating to profitability, solvency and liquidity of such business entities. As this is an era of cut throat competition, they want to compare the performance with similar firms in the existing market. Inter-firm and intra firm comparisons have to be carried out to know the exact position of an entity.
Furthermore, to judge the earning capacity of the firm, the managerial efficiency of the firm, these financial statements need to be scrutinised and analysed further. These financial statements constitute complex data, which has to be split into simple elements and relationships have to be established between these elements. Such process of division, establishing relationship and meaningful interpretation to understand efficiency is termed as “Analysis of Financial Statements”. Analysis of financial statements is a critical examination of the various elements in the financial statements so as to understand and take apt decisions with respect to entire operations of business entities.
Financial statements provide information on the various aspects namely – assets, liabilities on a specified date, revenues and expenses and the net result of operations during the specified period. In order to make the information more useful, such elements which form a part of financial statements have to be analysed in a systematic manner and there of after proper interpretation, they may be communicated to its users.
Myer defines Financial Statement Analysis as, “Financial statement analysis is largely a study of relationships among the various financial factors in a business as disclosed by a single set of statements, and a study of trends of these factors, as shown in a series of statements.”
It may also be said that the analysis of financial statements is a study of relationship among various financial facts and figures as setout in financial statements, that is, Balance Sheet and Income Statement.
Financial Analysis – various types of analysis is based on the material used, modus operandi and the objective of the analysis. These types of financial analysis are discussed briefly as follows.
This may further be classified into External Analysis and Internal Analysis.
External Analysis: In case, if a person may not have access to the detailed records of the company, external analysis is to be restored. One has to depend and rely on published financial statements. Persons engaged in external analysis include investors, credit agencies and governmental agencies. The role of external analysis have gained of such importance now-a-days. Such external records are reliable as governmental regulations enforce the business entities to make available needed information to the public.
Internal Analysis: This type of financial analysis is carried on by the persons who may have access to the detailed records (books of accounts and other information) of business entities. While conducting internal analysis such persons become part of the entities. For example, analysis for managerial discussions is an internal type of analysis, which is usually conducted by the employees of that business concern – naturally becomes part of that concern. At times, internal analysis is conducted by the statutory agencies.
This type of analysis may be classified into Horizontal Analysis and Vertical Analysis.
Horizontal Analysis: This is also known as “Dynamic Analysis.” In case, financial statements for a number of users are received and analysed, such analysis is referred to as “horizontal analysis.” It is based on data from year to year and not one date or period of time.
This type of financial analysis is useful for long term trend analysis and planning.
Vertical Analysis: This is also known as “Static Analysis.” Generally, it is based on data on one date or period of time. Vertical analysis is not of much use as one may not be able to analyse data in perspective.
The analysis on this basis may be of two types namely Short-term Analysis and Long-term Analysis.
Short-term Analysis: This type of analysis is conducted to compute the short-term solvency, liquidity and earning capacity of the business. Shot-term analysis is usually conducted to assess whether the business entities have enough to meet their short-term (requirements) contingencies.
Long-term Analysis: This type of analysis is conducted to determine of a business. This analysis is usually carried on to assess whether the business entities will be able to earn enough to meet its long-term obligations – profit, growth, modernisation and development of the business entities. This analysis is also useful to determine the effective rate of return on its investment.
Basis of Distinction | Horizontal Analysis | Vertical Analysis |
---|---|---|
1. Accounting Period |
It requires statements of two or more accounting periods. |
It requires a statement of one period. |
2. Items |
It deals with same item of different periods. |
It deals with different items of the same period. |
3. Information |
It provides information in absolute and percentage form. |
It provides information in percentage of money. |
4. Uses |
It is used for time series analysis. |
It is used for cross-section analysis. |
5. Comparison |
It is a part of comparison. |
It is a step towards comparison. |
Inter-firm and Intra-firm analysis of financial statements differs in the following aspects:
Basis of Distinction | Intra-firm Analysis | Inter-firm Analysis |
---|---|---|
1. Number |
It involves analysis of financial variables of one firm. |
It analyses the financial variables of two or more firms. |
2. Objective |
To determine the financial status of the firm and make decisions at management level. |
To make important comparisons and determine the competitive status of the firm. |
3. Other names |
It is also called as Time Series Analysis and Trend Analysis. |
When single set of information of two firms are compared, it is termed as cross-section analysis. |
4. Comparison with other firms |
Comparison with other firms may not be possible. |
Comparison with other firm is possible. |
Main functions used in the process of analysis are:
Re-classification and re-arrangement of data in financial statement is vital to get maximum information. This depends upon the purpose of analysis.
In case of a time series analysis, it is imperative to have comparative data of the same enterprise of the past periods. In case of cross-sectional analysis, it is essential to have comparative data of the same accounting period of the similar or comparative enterprises.
Comparative data, item are analysed with special reference to financial characteristics. (e.g., solvency, liquidity, profitability)
This is the concluding part. The interpretation should be precise. It should indicate the movement of various financial characteristics in the right direction.
Financial Analysis serves the following purposes and also that brings out the importance of such analysis.
On the basis of financial statements, the earning capacity of an enterprise may be computed. The future earning capacity may be forecasted. Investors very keenly observe this for making this investment.
The financial statement analysis is an indicator to pin point the strength and weakness of managerial efficiency. Favourable and unfavourable variations can be identified and the reasons thereof can be inferred, especially with the usage of financial ratios.
Short-term solvency and long-term solvency of the concern can be judged. Debenture holders are interested in long-term solvency and trade credits are interested is short-term solvency.
Financial statements of different concerns can be analysed and comparisons can be obtained. This comparison helps to assess its own performance as well as that of other firms. This analysis will give the desired results, if such comparison is based on ratios.
Analysis of financial statements will in a great way facilitates in forecasting future financial activities. Analysis also helps in preparation of budgets.
Following are the tools or techniques for analysing financial statements:
These are the statements in which figures for two or more periods are placed side by side along with the change in figures in absolute and percentage form. Both Balance Sheet and Profit and Loss Account are prepared in the form of Comparative Financial Statements.
These statements express all figures of a financial statement as percentage of some common base. In the Profit and Loss Account, sale figure is assumed to be 100 and all figures are expressed as a percentage of sales. In the Balance Sheet, the sum of assets or liabilities is assumed to be 100, and all the figures are expressed as percentage of total.
Any year may be taken on as the base year, each item of the base year is taken as 100. On that basis the percentage for each of the items of each of the following years are calculated.
It expresses the relationship between two variables (financial or accounting) taken from financial statements of an accounting period in the form of ratio.
It shows the sources from which cash was received and the purpose for which it was used. It shows the changes in cash position from one period to another.
It shows the sources from which Working Capital was got and the purpose for which it was used. It shows the changes in Working Capital position.
Now, each technique is explained in detail by way of illustrations as follows:
Comparative Financial Statements
These statements are prepared to show:
The tools for comparison and analysis of financial statements are
Comparative Balance Sheet analysis
A Comparative Balance Sheet is prepared as per Schedule VI of the Companies Act 1956. It is prepared by providing the columns:
Illustration: 1
From the following information, prepare a Comparative Balance Sheet of ABC Ltd:
Particulars | March 31, 2008 Rs | March 31, 2009 Rs |
---|---|---|
Equity Shares Capital |
30,00,000 |
30,00,000 |
Fixed Assets |
25,00,000 |
30,00,000 |
Reserves and Surplus |
4,00,000 |
4,50,000 |
Investments |
5,00,000 |
6,00,000 |
Long-term Loan |
10,00,000 |
10,00,000 |
Current Assets |
20,00,000 |
15,00,000 |
Current Liabilities |
6,00,000 |
6,50,000 |
(B. Com. Madras – Modified)
Solution
Comparative Balance Sheet
Note:
Example: Fixed Assets = Change/Base × 100 = 5,00,000/25,00,000 × 100 = 20%
The Comparative (P and L A/c) Income Statement shows:
It is prepared by providing the columns:
For each item, it is calculated this way, as in the case of Comparative Balance Sheets.
Illustration: 2
From the following, prepare Comparative Income Statement
Particulars | 2008 Rs |
2009 Rs |
---|---|---|
Sales |
2,00,000 |
3,00,000 |
Cost of Goods Sold |
(50,000) |
(60,000) |
|
1,50,000 |
2,40,000 |
Indirect Expenses |
(30,000) |
(40,000) |
|
1,20,000 |
2,00,000 |
Provision for Tax |
(20,000) |
(40,000) |
Net Profit after Tax |
1,00,000 |
1,60,000 |
(B.Com. Madras – Modified)
Solution
Comparative Income Statement
Notes: Workings
(i) |
Percentage change (Sales) = Absolute Change/Base Figure* × 100 = 1,00,000/2,00,000 × 100 = 50% |
(ii) |
Percentage change (Cost of Goods Sold) = 10,000/50,000 × 100 = 20% |
(iii) |
Percentage change (Gross Profit) = 90,000/1,50,000 × 100 = 60% |
(iv) |
Percentage change (Indirect Expenses) = 10,000/30,000 × 100 = 33.3% |
(v) |
Percentage change (Net Profit) = 80,000/1,20,000 × 100 = 66.67% |
(vi) |
Percentage change (Provision for Tax) = 20,000/20,000 × 100 = 100% |
(vii) |
Percentage change (Net Profit after Tax) = 60,000/1,00,000 × 100 = 60% |
*(viii) |
Base Figure: Value given in column year 2008 |
Accounting treatment of indirect expenses
Illustration: 3
Prepare Comparative Income Statement of X Ltd with the help of the following data:
Particulars | 2008 Rs |
2009Rs |
---|---|---|
Sales |
3,00,000 |
6,00,000 |
Cost of Goods Sold |
50% of Sales |
70% of Sales |
Indirect Expenses |
10% of Gross Profit |
10% of Gross Profit |
Rate of Income Tax |
50% of Net Before Tax |
50% of Net Before Tax |
B. Com. – Madras
Solution: Step I Cost of Goods Sold value has to be calculated
Sales = 2008 year = Rs 3,00,000
Cost of Goods Sold = 50% of Sales
= 50/100 × 3,00,000 = Rs 1,50,000
2009: Cost of Goods Sold = 70% of Sales
= 70/100 × 6,00,000 = Rs 4,20,000
Step II: Indirect Expenses to be calculated
This is computed from Gross Profit.
2008: Gross Profit = Sales − Cost of Goods Sold
= Rs 3,00,000 − Rs 1,50,000 = Rs 1,50,000
2008: Indirect Expenses = 10% of Gross Profit
= 10/100 × 1,50,000 = Rs 15,000
2009: Gross Profit = Rs 6,00,000 − Rs 4,20,000
= Rs 1,80,000
2009: Indirect Expenses = 10/100 × 1,80,000 = Rs 18,000
Step III: After deducting Indirect Expenses from Gross Profit, Net Profit before Tax is computed.
50% of this has to be deducted to arrive at Net Profit after Tax.
Percentage change is calculated as in previous illustration.
Comparative Income Statement
Illustration: 4
From the following, prepare a Common Size Income Statement
Solution
Common Size Income Statement
Notes: Students should note that, here, Net Sales for each year is taken as base.
For each item, with respect to Net Sales, percentage is calculated, for each year separately.
Percentage = Particular Value of Item/Net Sales × 100 = ….%
Workings
For the year 2008:
Like above, for these items, percentage can be calculated for each item, taking Net Sales for 2009, i.e. Rs 3,00,000, as base. (Students can do themselves.)
Common Size Comparative Balance Sheet
Illustration: 5
The Balance Sheet of XYZ Ltd as on March 31, 2008 and March 31, 2009 are given.
Prepare a Common Size Balance Sheet of XYZ Ltd for 2008 and 2009. You are required to comment on the changes.
Particulars | 2008 Rs |
2009 Rs |
---|---|---|
Shareholder’s Funds: |
||
Share Capital |
2,00,000 |
2,00,000 |
Reserves and Surplus |
20,000 |
10,000 |
|
2,20,000 |
2,10,000 |
Liabilities: |
||
Secured Loans |
50,000 |
80,000 |
Unsecured Loans |
1,50,000 |
60,000 |
Current Liabilities and Provisions |
80,000 |
50,000 |
Capital and Liabilities |
2,80,000 |
1,90,000 |
Assets: |
5,00,000 |
4,00,000 |
Fixed Assets (Net) |
3,00,000 |
2,40,000 |
Investments |
5,000 |
4,000 |
Inventories |
1,00,000 |
80,000 |
Debtors (Net) |
80,000 |
66,000 |
Cash |
15,000 |
10,000 |
Total Assets |
5,00,000 |
4,00,000 |
(B. Com. Madras University – Modified)
Solution
That is, Percentage = Particular item’s value/Total in B/S × 100 = …%
Common Size Balance Sheets of XYZ Ltd for the Year Ended March 31, 2008 and March 31, 2009
Comments: Major changes in the sources of funds.
Trend ratios may be defined as index numbers of the movements of the various factors (items) in the financial statements for a number of periods. It may also be statements for a number of periods. It may also be defined as a statistical device employed in the analysis of financial statements to reveal the trend of those item over a period of time. Trend ratios reflect the nature and rate of movements in various items (financial factors). This belongs to horizontal analysis type. Trend ratios may also be depicted graphically, which facilitates easy comprehensive. Trend ratios predict the movement of financial factors (future), which in turn helps to formulate and make proper management decisions. Any device or technique is not without its own limitations. Hithherto, trends may be affected by unforeseen economic conditions and police of government. Hence, it has to be dealt with extraordinary precaution.
Step 1: |
Statements for a number of years serve as a base. |
Step 2: |
Take one of the statements as the base. (Selection of statement should be done carefully. Generally, statement belonging to “normal year” of a business is to be taken as base.) |
Step 3: |
Each financial factor (item) in the base statement is taken as 100. |
Step 4: |
Trend percentage of each item in other statement (belonging to other years) is to be calculated with reference to the same item in the base statement by using the formula as: |
(Absolute value of item (in Rs) in other statements)/(Absolute value of same item (in Rs) in base statement) × 100.
Illustration: 6
From the following information extracted from the Balance Sheet of Good Luck Ltd for four previous financial years, calculate the trend percentages taking 2005–2006 as the base year.
Solution
Step 1: Base year is taken as 2005–2006 (given in the question).
Step 2: First, Cash (item or factor) – in the base year is taken as 100.
Step 3:
(Absolute value 2006–07)/(Absolute value 2006–07) × 100
= 720/600 × 100 = 120
= 1,200/600 × 100 = 200
= 660/600 × 100 = 110
Like this, for other items trend percentage can be calculated and tabulated as follows:
Trend Percentages
There are various users of financial statements, which are discussed as follows:
1. Investors: Investors – who are the real owners of the company are darely in need of financial statements in order to ascertain earnings for their investments and to assure the safety of it.
2. Lenders: There are so many types of lenders such as, debenture holders, suppliers of loans, leases and the like. Each is interested in assessing the capacity of the entity to repay debt with interest. Financial statements extend a helping hand to such users.
3. Creditors: Some creditors are eager to know the ability of the business to settle (repay) the amounts on the stipulated data.
4. Customers: Customers – in both senses – a regular suppliers of raw material to the company as well as a regular user of finished products of the company – are very much interested in knowing growth prospects of the company.
5. Employees: Employees (trade unions) use these statements for better bargaining of employments, perks, retirement benefit and so on.
6. Government and its agencies: Government, its agencies and various departments (Income Tax, Sales Tax, Excise) are interested in using these statements to formulate, operate, control and forecast policies pertaining to them.
7. Public: Now-a-days, public is interested in knowing the health of business entities. The use of financial statements cannot be underestimated as public awareness attains much significance.
Not withstanding the fact that financial statement analysis is helpful in assessing the financial position and earning capacity of a business entity, it is not free from certain shortcomings which are discussed below:
1. Ignores price level changes: Financial statements are complied on the basis of historical costs. It ignores price level changes and current economic real conditions. So any results arrived on analysis of financial statement may not reflect the real factor. Even Government regulations, tax structure, inflation all play a major role. Ignoring all such factors and analysing only the past factors may not serve the real purpose for which analysis is made.
2. Not absolute: Even though financial statements are expressed in exact money terms, the net result is not associated with absolute change in value. As the result, analysis will not be meaningful.
3. Accounting methods: Unless there is consistency and continuity in adopting accounting policies and techniques adopted by business entities, in such analysis, in the absence of consistency, the results may not be comparable and that too they will be biased.
4. Skilled analysis: It will be an effective tool only if the financial statements are analysed by skilled accountants. Analysis done by unskilled men may lead to erroneous conclusions.
5. Interim reports: Generally, financial statements are interim reports and not final. True gain or loss can be computed only at the termination of business. Financial statements prepared periodically may only reflect the way in which the business moves.
6. Different interpretations: The results derived from analysis of financial statements are generally interpreted differently by the different users of financial statements. There are no standard interpretations in practice. No common procedure exists.
7. Limited Usage: The analysis of financial statement in respect of a single year usually may not be of much help, as comparison cannot be made based on the results of more than one year. To arrive at a precise and reliable conclusion, analysis must be extended over a number of years.
8. Lacks accuracy: At times, the income statement of the balance sheet are manipulated. Such manipulations affect the accuracy of figures in the final statement. The reliability of analysis is affected to a great extent, as they lack accuracy.
9. Faulty forecast: Analysis of financial statements is made on the basis of past records. Factors analysed on past events may not serve as a better indicator for future forecasting as many external factors affect the business transactions of an enterprise which are beyond its control. As such future forecast may not be perfect.
10. Different tools: There are many different tools or techniques available for the analysis of financial statements. Naturally results will vary due to the variance in technique and persons whose skill employed in analysis of financial statements.
Financial statements are the summarised statements of accounting data. It is prepared at the end of the accounting year. (Its preparation is discussed in detail in Chapter 5, “Accounting Process – Preparation of Final Accounts from Trial Balance”.) Usually a set of financial statements include:
These statements are very much useful to investors, lenders, suppliers, trade creditors, customers, consumers, governments and statutory bodies and employees – which had been discussed in the chapter “Final Accounts.”
As per the Companies Act 1956, it is statutory, for the board of directors to attach Annual Report along with Financial Statements.
Board of Directors of a company will have to prepare a report to be presented at the Annual General Meeting of shareholders of the company. The meeting has to be convened every year. Its main agenda is to approve annual accounts and other related matters of urgent importance. Director’s Report must be attached to the Balance Sheet, to be presented before the shareholders at the annual meeting. The board of directors will be required to make a report comprising important contents as stipulated by Sec. 217 of the Companies Act, 1956. Main contents of the report of board of directors are:
As an auditor of a company, he has to express his opinion on the annual accounts, in a statement called “Auditor’s Report to the Shareholders”.
It is the statutory duty of an auditor to include in his report, a statement on such matters, as may be specified.
As already said, Balance Sheet is a statement of company’s asset and liabilities on a particular date. The prescribed form of Balance Sheet is given in Part I of Schedule VI of the Companies Act, 1956. The Act has laid down two forms. They are:
Horizontal Form of Balance Sheet of ……Ltd as on
Vertical Form of Balance Sheet of …. Ltd as on …
Balance Sheet of…(Here, enter the name of Company) as on …… Here, enter the date on which B/S is made of)
The following are the assets under different headings:
Less: Provision for Doubtful Debts
Cash and Bank Balance
Profit and Loss Account:
Two types of items are shown on the Liabilities side:
Type 1: |
Items that are related to owner’s equity. It includes share capital, reserves and surplus. |
Type 2: |
Items that create the claims of creditors. It includes secured loans, unsecured loans, provisions and current liabilities. |
The above mentioned items put in the order, on the Assets and Liabilities side of the Balance Sheet in the prescribed format, one can easily understand the Schedule VI, Part Sec. 211 of the Companies Act, 1956.
In compliance with the requirements of Part II of Schedule VI, Profit and Loss Account (comprises) is divided into three parts:
|
Part I |
Trading Account |
|
Part II |
Profit and Loss Account |
|
Part III |
Profit and Loss Appropriation Account |
Trading Account is prepared to ascertain gross profit or loss during a year.
Profit and Loss Account is prepared to ascertain net profit or loss during a year.
Profit and Loss Appropriation Account is prepared to know how the net profit has been invested.
After ascertaining the net profit, then arises the question of distribution of profit, that is, appropriation. Same portion of profit as distributed among shareholders is dividend. Some portion of profit is kept with the company and it is shown on the credit side of Profit and Loss Account. The items that are shown on the debit side:
The Trial Balance of profit after above appropriations is carried forward to next year’s account. This part of Profit and Loss Account is known as Profit and Loss Appropriation Account. This part of the account showing appropriation of profit is also called as “Below the Line” Account. The other part is called as “Above the Line” Account.
Profit and Loss Account may also be preserved both in horizontal as well as vertical forms. But, mostly companies prefer vertical form of presentation of Profit and Loss Account. The most widely used formats are shown here for both horizontal and vertical forms of Profit and Loss Account. A generally adapted format of the Trading and Profit and Loss Account is given below:
Trading and Profit and Loss Account for the year ended………
Trading and Profit and Loss Account may be prepared in a vertical form also. A format of the vertical form is given below:
Trading and Profit and Loss Account for the year ended …….
Particulars | Rs | Rs |
---|---|---|
Sales |
— |
xx |
Less: Returns |
— |
|
Less: Cost of Goods Sold |
— |
|
Opening Stock |
— |
|
Purchases (Net) |
— |
|
Wages |
— |
|
Power and Fuel |
— |
|
Job Work Charges |
— |
|
Carriage Inwards |
— |
|
Other Direct Expenses |
— |
|
Sub-total |
— |
|
Less: Closing Stock |
— |
— |
|
_____ |
|
Gross Profit |
— |
xxx |
Less: Operating Expenses |
— |
— |
Office Expenses |
— |
|
Administrative Expenses |
— |
|
Selling and Distribution Expenses |
— |
— |
Operating Profit |
— |
xxx |
|
_____ |
_____ |
Add: Non-operating Income |
— |
|
Interest |
— |
|
Profit on Sale Fixed Assets |
— |
— |
Less: Non-operating Income |
— |
|
Loss by Fire/Theft |
— |
— |
Net Profit before Interest and Tax |
— |
xxx |
Interests on Loans |
— |
|
Interest on Debentures |
— |
— |
Net Profit before Tax |
— |
xx |
Provision for Tax |
— |
|
Net Profit available for Appropriations |
— |
xx |
Proposed Dividend |
— |
— |
Debenture Redemption Reserve |
— |
|
General Reserve |
— |
— |
|
_____ |
_____ |
Profit and Loss Account |
xxx |
|
|
_____ |
_____ |
This is the statement attached to the financial statements (as required in Schedule VI). This contains accounting policies adopted. This gives better insight into company’s state of affairs.
This is statement indicating the flow of cash (inflow and outflow) during an accounting year. This is discussed in Chapter 17 “Cash Flow Statement.”
Illustration: 7
The Profit and Loss Accounts of Star and Co. for the years ended March 31, 2008 and 2009 are:
Particulars | 2008 Rs |
2009 Rs |
---|---|---|
Net Sales |
4,85,000 |
4,25,000 |
Cost of Goods Sold |
2,60,000 |
2,45,000 |
Gross Profit |
4,85,000 |
4,25,000 |
Operating Expenses |
60,000 |
45,000 |
Net Profit |
1,65,000 |
1,35,000 |
You are required to prepare a Comparative Profit and Loss Account.
Solution
Comparative Profit and Loss Statement
Comment: Results are negative, i.e. decrease in all items.
Working Notes
Illustration: 8
From the following data, prepare a Statement of Profit in the Comparative Form:
Particulars | 2008 Rs |
2009 Rs |
---|---|---|
Sales |
4,00,000 |
4,00,000 |
Gross Profit Ratio |
30% |
40% |
Administrative Expenses |
25,000 |
50,000 |
Income Tax |
50% |
50% |
Solution
Step 1:
Sales – Cost of Goods Sold = Gross Profit
100% – C.G.S. = 30% (Given)
Hence cost of goods sold: 100% – 30% = 70%
70% of Rs 4,00,000 = Rs 2,80,000
C.G.S = 100% – 40% = 60% (Given)
60% of Rs 4,00,000 = Rs 2,40,000
Step 2:
Net Profit = Rs 95,000
50% = Rs 47,500
50% of Rs 1,10,000 = Rs 55,000
Step 3: Percentage, absolute change is to be calculated as in the previous illustration and tabulated as:
Comment:
Illustration: 9
Prepare a Comparative Income Statement of Exe Ltd from the following information:
Particulars | 2008 | 2009 |
---|---|---|
Sales |
Rs 2,00,000 |
Rs 4,00,000 |
Cost of Goods Sold |
60% of Sales |
70% of Sales |
Indirect Expenses |
10% of Gross Profit |
|
Rate of Income Tax |
50% of Net Profit before Tax |
|
Solution
Comparative Income Statement
Comment
Illustration: 10
Prepare a common size Balance Sheet and pass your comments based on the results of analysis from the following extracts of balance sheets of A Ltd and B Ltd as at December 31, 2009.
Solution
Step 1: For A Ltd:
Fixed Assets/Total Assets × 100 = 20,00,000/(20,00,000 + 10,00,000) × 100 = 66.67%
Current Assets/Total Assets × 100 = 10,00,000/30,00,000 × 100 = 33.33%
Step 2: For B Ltd:
32,00,000/36,00,000 × 100 = 88.88%
4,00,000/36,00,000 × 100 = 11.12%
Step 3:
For A Ltd (Liabilities); |
For B Ltd |
(i) Share Capital: 18,00,000/30,00,000 × 100 = 60%; |
(i) 24,00,000/36,00,000 × 100 = 66.67% |
(ii) Reserves and Surplus: 8,00,000/30,00,000 × 100 = 26.67%; |
(ii) 7,00,000/36,00,000 × 100 = 19.4% |
(iii) Current Liabilities: 4,00,000/30,00,000 × 100 = 13.33%; |
(iii) 5,00,000/36,00,000 × 100 = 13.89% |
Step 4: These results are to be represented in the tabular form as below:
Common Size Balance Sheet of A Ltd and B Ltd as on December 31, 2009
Comments
Current Assets >Current Liabilities
33.33% >13.33%
Current Assets < Current Liabilities
11.12% < 13.89%
Illustration: 11
Alternative method: Preparation of Comparative Balance Sheet
Prepare Comparative Balance Sheet of ABC Ltd. from the following information.
Solution
Comparative Balance Sheet of ABC Ltd.
For the Years as on 2008 and 2009
Annual Report: A combination of financial statements, management discussion, analysis, graphs and charts provided periodically to shareholders.
Balance Sheet: A statement showing the financial position of a business enterprise on a particular date.
Common Size Statements: Financial statements expressed in component percentages.
Financial Statement Analysis: Analysis of financial statements to assess the firms viability.
Income Statement: A consolidated account (report) of all revenues and expenses for a specific period.
Solvency: A firm’s ability to meet its financial obligation (on the maturity date) as they become due.
Time series: Comparison of firm’s financial ratios with its own previous year’s ratios.
Trend Ratios: Index numbers of the movements of the various items in the financial statements for a number of periods.
Horngreen Sundem & Elliott, “Introduction to Financial Accounting”, Pearson Education, 2004, New Delhi.
White Gerald I, “Analysis and Use of Financial Statements”, John Wilsey & Sons, 1998, New York.
Helbert E.A., “Technique of Financial Analysis”, Richard D. Irwin, Hamewood 911, 1972.
I. State whether the following statements are True or False
Answers
1. True |
2. False |
3. True |
4. True |
5. False |
6. True |
7. False |
8. False |
9. True |
10. True |
II. Fill in the blanks with appropriate word(s)
Answers
1. From the following summarised balance sheets, prepare a Comparative Balance Sheet and comment upon the changes:
2. From the following summarised balance sheets, prepare a Comparative Balance Sheet and comment upon the changes in absolute figures from one period to another.
3. Prepare a Comparative Balance Sheet from the following:
Particulars | 2008 Rs |
2009 Rs |
---|---|---|
Assets: |
1,00,000 |
1,20,000 |
Fixed Assets |
80,000 |
1,00,000 |
Current Assets |
1,80,000 |
2,20,000 |
Liabilities: |
||
Share Capital |
1,00,000 |
1,40,000 |
Reserves |
10,000 |
5,000 |
Sundry Creditors |
70,000 |
75,000 |
|
1,80,000 |
2,20,000 |
4. From the following summarised balance sheets of a company, you are required to prepare Comparative Balance Sheet with comments on changes from one period to another.
5. Prepare a Comparative Balance Sheet from:
Model: Comparative Income Statement
6. From the following information, prepare a Comparative Income Statement showing increases, decreases and percentages:
Particulars | 2008 Rs |
2009 Rs |
---|---|---|
Sales |
1,00,000 |
1,60,000 |
Cost of Goods Sold |
80,000 |
1,00,000 |
Administrative Expenses |
5,000 |
5,000 |
Selling Expenses |
8,000 |
12,000 |
Other income |
7,000 |
10,000 |
Income Tax |
10,000 |
16,000 |
7. Convert the following income statement into Comparative Income Statement:
Income Statement
Particulars | 2008 Rs |
2009 Rs |
---|---|---|
Sales |
2,00,000 |
3,00,000 |
Cost of Goods Sold |
80,000 |
1,00,000 |
|
1,20,000 |
2,00,000 |
Selling and Distribution Expenses |
50,000 |
55,000 |
Administrative Expenses |
20,000 |
25,000 |
|
70,000 |
80,000 |
Income from Operation |
50,000 |
1,20,000 |
Other Expenses |
5,000 |
12,000 |
Net Income for the year |
45,000 |
1,08,000 |
8. Convert the following income statement into Comparative Income Statement and in the light of the conditions in 2008, interpret the changes in 2009:
Income Statement
Particulars | 2008 Rs |
2009 Rs |
---|---|---|
Gross Sales |
2,05,000 |
3,10,000 |
Sales Returns |
5,000 |
10,000 |
Net Sales |
2,00,000 |
3,00,000 |
Cost of Sales |
60,000 |
90,000 |
|
1,40,000 |
2,10,000 |
Operating Expenses: |
||
Sales Expenses |
30,000 |
45,000 |
Administrative Expenses |
10,000 |
15,000 |
Total Expenses |
40,000 |
60,000 |
Income from Operations |
1,00,000 |
1,50,000 |
Other income |
10,000 |
15,000 |
Total Income |
1,10,000 |
1,65,000 |
Other Expenses |
20,000 |
30,000 |
Net Income for the year |
90,000 |
1,35,000 |
9. From the following information, prepare statement of profits in comparative form:
Particulars | 2008 | 2009 |
---|---|---|
Sales |
9,00,000 |
12,00,000 |
Gross Profit |
30% |
40% |
Office and Administrative Expenses |
90,000 |
1,20,000 |
Income Tax Rate |
50% |
50% |
10. From the following data, prepare a Comparative Income Statement:
Particulars | 2008 Rs |
2009 Rs |
---|---|---|
Purchases |
1,20,000 |
1,50,000 |
Manufacturing Expenses |
12,000 |
15,000 |
Stock Adjustment |
(–7,000) |
(+5,000) |
Total |
1,25,000 |
1,70,000 |
Gross Profit |
25,000 |
34,000 |
|
1,00,000 |
1,36,000 |
11. Prepare a Comparative Income Statement from the following data:
Particulars | 2008 | 2009 |
---|---|---|
Sales |
Rs 8,00,000 |
Rs 10,00,000 |
Cost of Goods Sold |
40% of Sales |
60% of Sales |
Indirect Expenses |
60% of Gross Profit |
40% of Gross Profit |
Income Tax |
50% of Net Profit before Tax |
50% of Net Profit |
Model: Common Size Balance Sheet
12. From the following balance sheets of Rainbow Ltd on March 31, 2009 and 2010, you are required to prepare a Common Size Balance Sheet.
Balance Sheets of Rainbow Ltd as at March 31
13. Prepare a Common Size Balance Sheet from the following balance sheets of Ajay Ltd & Vijay Ltd as at December 31,2009:
Model: Common Size Income Statement
14. From the following, prepare a Common Size Income Statement:
Particulars | Year I Rs |
Year II Rs |
---|---|---|
Sales |
6,00,000 |
10,00,000 |
Cost of Goods Sold |
4,00,000 |
6,00,000 |
Selling and Distribution Expenses |
40,000 |
80,000 |
Interest on Loan |
60,000 |
60,000 |
Income Tax |
25,000 |
20,000 |
15. You are required to prepare a Common Size Income Statement from the following data:
Particulars | Year I Rs |
Year II Rs |
---|---|---|
Sales |
16,00,000 |
2,00,000 |
Cost of Goods Sold |
9,60,000 |
10,20,000 |
Administrative Expenses |
1,28,0000 |
1,60,000 |
Selling and Distribution Expenses |
64,000 |
80,000 |
Interest on Loan |
85,000 |
85,000 |
Income Tax |
42,000 |
40,000 |
16. From the following information extracted from the balance sheets of V.R.S. Ltd, of four previous years, you are required to compute the Trend percentage taking 2005–06 as the base year:
13.59.106.174