| Accountancy NCERT Notes, Solutions and Extra Q & A (Class 11th & 12th) | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11th | 12th | ||||||||||||||||||
| Class 12th Chapters | ||
|---|---|---|
| Accountancy - Not-for-Profit Organisation | ||
| 1. Accounting For Not-For-Profit Organisation | 2. Accounting For Partnership : Basic Concepts | 3. Reconstitution Of A Partnership Firm – Admission Of A Partner |
| 4. Reconstitution Of A Partnership Firm – Retirement/Death Of A Partner | 5. Dissolution Of Partnership Firm | |
| Accountancy - Company Accounts and Analysis of Financial Statements | ||
| 1. Accounting For Share Capital | 2. Issue And Redemption Of Debentures | 3. Financial Statements Of A Company |
| 4. Analysis Of Financial Statements | 5. Accounting Ratios | 6. Cash Flow Statement |
Chapter 4 Analysis Of Financial Statements Concepts, Solutions and Extra Q & A
This chapter introduces the Analysis of Financial Statements as a critical process of evaluating a company's financial information to assess its performance, profitability, and overall financial health. It is not merely about simplifying data (analysis) but also about explaining its meaning and significance (interpretation). The key purpose is to aid various stakeholders in making informed economic decisions. The chapter details several analytical tools, with a primary focus on Comparative Statements (horizontal analysis) for tracking changes over time and Common-Size Statements (vertical analysis) for understanding the structural composition of assets, liabilities, and expenses.
The significance of this analysis is highlighted for different users: investors assess profitability, creditors gauge liquidity and solvency, and management evaluates operational efficiency. However, the analysis has inherent limitations because it is based on historical financial data. It ignores the impact of inflation, overlooks crucial non-monetary factors like management quality and employee morale, and can be skewed by personal judgments or changes in accounting policies. Therefore, while financial analysis is a powerful tool, its conclusions must be drawn with a clear understanding of these constraints.
Meaning of Analysis of Financial Statements
The Analysis of Financial Statements is the process of conducting a critical evaluation of the financial information contained within a company's Balance Sheet, Statement of Profit and Loss, and other related reports. The primary goal is to transform raw financial data into meaningful information to gain a deeper understanding of the company's operational efficiency, profitability, and overall financial health. This process is essential for making informed business, credit, and investment decisions.
It is fundamentally a study of the relationships among various financial facts and figures. The entire process involves two distinct but inseparable components:
Analysis: This is the first step, involving the simplification and methodical classification of the data presented in the financial statements. It is the mechanical aspect of breaking down large, complex sets of data into more manageable and understandable components. This can involve regrouping items, calculating changes in figures over time, or computing ratios and percentages. For example, calculating the percentage of expenses to sales is an act of analysis.
Interpretation: This is the second and more critical step, which involves explaining the meaning and significance of the analyzed data. Interpretation answers the 'why' and 'so what' behind the numbers. It involves drawing conclusions about the company's strengths and weaknesses. For example, concluding that a rising percentage of expenses to sales indicates declining operational efficiency is an act of interpretation.
These two components are completely complementary. Analysis is useless without interpretation, as it would just be a collection of isolated numbers and percentages. Similarly, interpretation is difficult or even impossible without analysis, as there would be no simplified data to explain. Together, they form a judgmental process aimed at evaluating a company's past performance and present financial position to make the best possible predictions about its future prospects.
The analysis can be conducted through two primary modes of comparison:
Cross-sectional analysis (Inter-firm comparison): This involves comparing a company's financial data with that of other firms in the same industry or with industry averages for the same period. This helps in assessing the company's performance relative to its competitors.
Time-series analysis (Intra-firm comparison): This involves comparing a company's own performance over a period of time (e.g., over the last three to five years). This helps in identifying trends and determining whether the company's financial health is improving, deteriorating, or remaining constant.
Significance of Analysis of Financial Statements
Financial analysis is a crucial process for identifying the financial strengths and weaknesses of a firm by establishing and studying the relationships between items in the Balance Sheet and the Statement of Profit and Loss. Its significance is vast as it provides valuable insights to a wide range of stakeholders, both internal and external to the organization, each with their own specific interests and objectives.
Significance to Different Users
Finance Manager: For the finance manager, financial analysis is an indispensable tool for rational decision-making. It helps in assessing managerial performance, corporate efficiency, and creditworthiness. By analyzing financial data, a finance manager can review operating policies, determine the investment value of the business, and implement effective financial control by identifying and correcting deviations from planned performance.
Top Management: The top management team is responsible for the overall performance and strategic direction of the company. Financial analysis helps them measure the success of operations, appraise the performance of individual departments and managers, and evaluate the effectiveness of the internal control systems. It provides a comprehensive view of the company's financial health, ensuring that its resources are being used in the most efficient manner.
Trade Payables (Creditors): Trade payables, such as suppliers of raw materials, are primarily interested in the company's ability to meet its short-term obligations. They analyze financial statements to assess the company's liquidity position. This helps them decide whether to extend credit to the company and on what terms, giving them confidence that their claims will be paid on time.
Lenders (Long-term): Suppliers of long-term debt, including banks and debenture holders, are concerned with the company's long-term solvency and survival. Their analysis focuses on profitability trends over time, the company's ability to generate cash to pay interest and repay the principal, and its overall capital structure. Historical financial analysis helps them assess the long-term risk associated with their lending.
Investors: Investors, who have committed their capital to the company's shares, are primarily interested in the firm's earnings and profitability, both present and future. They analyze the financial statements to assess the return on their investment and the associated risks. This analysis is fundamental to their decisions to buy, sell, or hold the company's shares.
Labour Unions: Labour unions analyze a company's financial statements to assess its profitability and capacity to afford wage increases. The analysis provides a factual basis for collective bargaining and wage negotiations, as it provides evidence of whether the company can absorb higher wages through increased productivity or by raising the prices of its products.
Others: The significance of financial analysis extends to other parties as well. Economists and researchers use financial statements to study business trends and overall economic conditions. Government agencies use them for purposes like price regulation, taxation, and formulating economic policies related to the corporate sector. Customers may also be interested in the long-term viability of a company, especially if they are dependent on it for a critical product or service.
Objectives of Analysis of Financial Statements
The primary purpose of analyzing financial statements is to extract meaningful information that reveals the strengths and weaknesses of a firm, which can then be used for forecasting future performance and making informed decisions. The analysis aims to transform complex and absolute financial data into understandable and actionable insights by studying the relationships between various financial variables.
The specific objectives of conducting a financial analysis are as follows:
To assess profitability and operational efficiency: A key objective is to measure the company's earning capacity and to evaluate how efficiently it is utilizing its assets and other resources to generate profits. This involves analyzing profit margins, return on investment, and the relationship between sales and assets. This assessment helps in judging the overall financial health and performance of the firm.
To ascertain the relative importance of financial components: Financial analysis helps in understanding the composition and structure of the company's financial position. It aims to determine the proportion of different types of assets, liabilities, and equity in the Balance Sheet. For example, it helps answer questions like: How much of the company's assets are financed by debt versus equity? What percentage of total assets are current assets?
To identify the reasons for change: By comparing financial statements over two or more periods, the analysis aims to identify the underlying causes behind any significant changes in the company's profitability or financial position. For instance, if the net profit has decreased despite an increase in sales, analysis can help pinpoint whether the cause was a rise in the cost of goods sold, an increase in operating expenses, or higher interest costs.
To judge the ability to repay debt (Assessing Liquidity and Solvency): A critical objective is to assess the firm's ability to meet its financial obligations. This is done at two levels:
- Liquidity: Assessing the company's ability to meet its short-term obligations as they become due. This is of primary interest to short-term creditors.
- Solvency: Assessing the company's ability to meet its long-term debts and to survive over a long period of time. This is a key concern for long-term lenders and investors.
Additionally, on a broader level, the analysis of financial statements of various firms helps economists and government bodies. It allows them to judge the extent of concentration of economic power in certain industries and to evaluate the impact of financial policies. This analysis also provides the basis for many governmental actions, such as those relating to licensing, price controls, dividend freeze policies, tax subsidies, and other concessions to the corporate sector.
Tools of Analysis of Financial Statements
Financial analysts employ several techniques or tools to dissect and interpret the information contained in financial statements. Each tool provides a different perspective on the company's performance and financial position, and often, multiple tools are used in conjunction to get a comprehensive understanding.
The most commonly used tools of financial analysis are as follows:
1. Comparative Statements
These statements present financial data for two or more accounting periods side-by-side in columns to facilitate comparison. Both the Balance Sheet and the Statement of Profit and Loss are prepared in a comparative format. This tool not only shows the absolute figures for each period but also calculates the absolute change (increase or decrease) and the percentage change for each line item from one period to another. This allows analysts to easily identify the magnitude, trend, and direction of change in the company's performance and financial position. Because this method involves comparing figures across different time periods (horizontally across the columns), this technique is also known as ‘horizontal analysis’.
2. Common-Size Statements
In these statements, each line item is expressed as a percentage of a common base item from the same statement for a single accounting period. This process converts the entire financial statement into percentages, showing the relative size of each component.
For the Statement of Profit and Loss, the common base is usually 'Revenue from Operations', which is set to 100%. Every expense and profit figure is then shown as a percentage of this revenue. This helps in assessing the operational efficiency and profitability structure.
For the Balance Sheet, the base is 'Total Assets' or 'Total Equity and Liabilities', which is set to 100%. Each asset is expressed as a percentage of total assets, and each liability and equity item is expressed as a percentage of the total. This reveals the composition of assets and the financing mix of the company.
The primary advantage of common-size statements is that they facilitate the comparison of companies of different sizes. Because this method involves analyzing the relationships between items within a single period (vertically down a single column), this technique is also known as ‘vertical analysis’.
3. Trend Analysis
This technique involves analyzing financial data over a series of several years (typically 3 to 5 years or more) to identify underlying long-term trends. A base year is selected and its figures for each item are taken as 100. The figures for the same items in all subsequent years are then expressed as a percentage of the base year's figure. This results in a series of 'trend percentages'. Trend analysis provides a long-run view of a company's performance and can highlight basic changes in its growth, profitability, and financial structure, indicating whether a particular item is consistently rising, falling, or remaining stable.
4. Ratio Analysis
This is one of the most widely used techniques of financial analysis. It involves calculating and analyzing various financial ratios to describe the significant relationships that exist between different items on the financial statements. Ratios are a powerful tool because they simplify complex financial information into a single, easy-to-understand number. They are used to assess a company's performance in four key areas:
- Profitability Ratios: Measure the company's ability to generate profit.
- Liquidity Ratios: Measure the company's ability to meet its short-term obligations.
- Solvency Ratios: Measure the company's ability to meet its long-term debt obligations.
- Efficiency (or Turnover) Ratios: Measure how efficiently the company is using its assets.
Ratios provide a standardized way to compare performance across different periods and companies.
5. Cash Flow Analysis
This involves the preparation and analysis of the Cash Flow Statement, which shows the actual movement of cash into (inflows) and out of (outflows) an organization during a specific period. The statement categorizes these cash flows into three main activities: Operating, Investing, and Financing. Cash flow analysis is crucial because profit shown on the Statement of Profit and Loss (which is based on accrual accounting) is not the same as the cash generated. This analysis helps in assessing a company's ability to generate cash, meet its obligations, pay dividends, and fund its investments without relying on external financing.
Comparative Statements
Comparative statements are a form of horizontal analysis where the financial statements (Balance Sheet and Statement of Profit and Loss) of two or more consecutive periods are presented side-by-side in columns. This format is designed for easy comparison and trend analysis. In addition to showing the absolute figures for each period, these statements include two extra columns that calculate the absolute change (increase or decrease) and the percentage change for each line item between the periods. This allows users to quickly identify the magnitude, direction, and significance of changes in the performance and financial position of the organization.
Steps to Prepare Comparative Statements and Derivation of Formulas
The preparation of a comparative statement is a systematic process involving the following steps:
Step 1: Data Arrangement
Arrange the absolute financial figures for two different periods (e.g., Previous Year and Current Year) in the first two numerical columns. The previous year is typically used as the base for comparison.
Step 2: Calculation of Absolute Change
Calculate the absolute change for each line item by subtracting the previous year's figure from the current year's figure. This value is placed in the third column.
Derivation/Formula:
$ \text{Absolute Change} = (\text{Current Year's Figure}) - (\text{Previous Year's Figure}) $
This result shows the absolute increase (+) or decrease (-) in monetary terms (e.g., Rupees).
Step 3: Calculation of Percentage Change
Calculate the percentage change for each item and place it in the fourth column. This shows the relative change and is particularly useful for understanding the significance of the change.
Derivation/Formula:
$ \text{Percentage Change} = \frac{\text{Absolute Change}}{\text{Previous Year's Figure}} \times 100 $
If the previous year's figure is zero or negative, the percentage change cannot be meaningfully calculated and is usually marked as 'N/A' or left blank.
Illustration 1. Convert the following statement of profit and loss of BCR Co. Ltd. into a comparative statement.
| Particulars | 2019-20 ($\text{₹} \ $) | 2020-21 ($\text{₹} \ $) |
|---|---|---|
| Revenue from operations | 60,00,000 | 75,00,000 |
| Other incomes | 1,50,000 | 1,20,000 |
| Expenses | 44,00,000 | 50,60,000 |
| Income tax | 35% | 40% |
Answer:
Comparative Statement of Profit and Loss of BCR Co. Ltd.
for the years ended March 31, 2020 and 2021
| Particulars | 2019-20 ($\text{₹} \ $) (A) |
2020-21 ($\text{₹} \ $) (B) |
Absolute Change ($\text{₹} \ $) (C = B - A) |
Percentage Change (%) (D = C/A × 100) |
|---|---|---|---|---|
| I. Revenue from Operations | 60,00,000 | 75,00,000 | +15,00,000 | +25.00 |
| II. Add: Other Incomes | 1,50,000 | 1,20,000 | -30,000 | -20.00 |
| III. Total Revenue (I+II) | 61,50,000 | 76,20,000 | +14,70,000 | +23.90 |
| IV. Less: Expenses | 44,00,000 | 50,60,000 | +6,60,000 | +15.00 |
| V. Profit before Tax (III-IV) | 17,50,000 | 25,60,000 | +8,10,000 | +46.29 |
| VI. Less: Tax (35% & 40%) | 6,12,500 | 10,24,000 | +4,11,500 | +67.18 |
| VII. Profit after Tax (V-VI) | 11,37,500 | 15,36,000 | +3,98,500 | +35.03 |
Interpretation:
The analysis shows that while Total Revenue increased by 23.90%, the Expenses increased at a slower rate of 15.00%. This efficient cost management led to a significant increase in Profit Before Tax by 46.29%. Although the tax expense grew at a faster rate due to a higher tax rate, the final Profit After Tax still showed a healthy growth of 35.03%.
Illustration 2. The following are the Balance Sheets of J. Ltd. as at March 31, 2020 and 2021. Prepare a Comparative Balance Sheet.
| Particulars | 2020 ($\text{₹} \ $) | 2021 ($\text{₹} \ $) |
|---|---|---|
| Equity and Liabilities | ||
| Share Capital | 15,00,000 | 20,00,000 |
| Reserve and Surplus | 4,00,000 | 3,00,000 |
| Long-term borrowings | 6,00,000 | 9,00,000 |
| Trade payables | 2,00,000 | 3,00,000 |
| Total | 27,00,000 | 35,00,000 |
| Assets | ||
| Property, Plant and Equipment | 21,00,000 | 29,00,000 |
| Inventories | 4,00,000 | 3,00,000 |
| Cash and cash equivalents | 2,00,000 | 3,00,000 |
| Total | 27,00,000 | 35,00,000 |
Answer:
Comparative Balance Sheet of J. Limited
as at March 31, 2020 and March 31, 2021
| Particulars | 2020 ($\text{₹} \ $) (A) |
2021 ($\text{₹} \ $) (B) |
Absolute Change ($\text{₹} \ $) (C = B - A) |
Percentage Change (%) (D = C/A × 100) |
|---|---|---|---|---|
| I. EQUITY AND LIABILITIES | ||||
| 1. Shareholders’ Funds | ||||
| a) Share capital | 15,00,000 | 20,00,000 | +5,00,000 | +33.33 |
| b) Reserve and surplus | 4,00,000 | 3,00,000 | -1,00,000 | -25.00 |
| 2. Non-current Liabilities | ||||
| a) Long-term borrowings | 6,00,000 | 9,00,000 | +3,00,000 | +50.00 |
| 3. Current Liabilities | ||||
| a) Trade payables | 2,00,000 | 3,00,000 | +1,00,000 | +50.00 |
| Total Equity and Liabilities | 27,00,000 | 35,00,000 | +8,00,000 | +29.63 |
| II. ASSETS | ||||
| 1. Non-current Assets | ||||
| a) Property, Plant and Equipment | 21,00,000 | 29,00,000 | +8,00,000 | +38.10 |
| 2. Current Assets | ||||
| a) Inventories | 4,00,000 | 3,00,000 | -1,00,000 | -25.00 |
| b) Cash and cash equivalents | 2,00,000 | 3,00,000 | +1,00,000 | +50.00 |
| Total Assets | 27,00,000 | 35,00,000 | +8,00,000 | +29.63 |
Interpretation:
The company has expanded its operations, as indicated by the 29.63% increase in total assets. This expansion was financed by raising additional share capital (+33.33%) and long-term borrowings (+50.00%). The increase in Property, Plant and Equipment suggests investment in productive capacity. While cash has increased by 50%, there is a notable decrease in inventories (-25%) and reserves and surplus (-25%), which may require further investigation.
Common-Size Statements
Common-size statements, also known as component percentage or 100-percent statements, are a powerful tool of vertical analysis. In these statements, each line item is expressed as a percentage of a common base figure from the same statement. This technique converts absolute monetary figures into relative percentages, which makes it easy to analyze the internal structure of the company's finances and to compare it with other companies, especially those of different sizes.
For a Common-Size Statement of Profit and Loss, the common base is Revenue from Operations, which is always taken as 100%. All other items, including cost of goods sold, operating expenses, and profits, are then shown as a percentage of this revenue. This helps in understanding the cost structure and profitability relative to sales.
For a Common-Size Balance Sheet, the common base is Total Assets or Total Equity and Liabilities (which are always equal), taken as 100%. Each individual asset is expressed as a percentage of total assets, and each item of equity and liability is expressed as a percentage of total equity and liabilities. This reveals the composition of assets and the financing mix (capital structure) of the company.
This analysis is immensely useful for both intra-firm comparison (analyzing trends in the financial structure of the same company over different years) and inter-firm comparison (comparing the company with its competitors or industry averages).
Steps to Prepare Common-Size Statements and Derivation of Formulas
The preparation process is straightforward:
Step 1: Data Arrangement
List the absolute financial figures for the periods to be analyzed in separate columns.
Step 2: Identify the Base Figure
For the Statement of Profit and Loss, the base is 'Revenue from Operations'. For the Balance Sheet, the base is 'Total Assets' (or Total Equity & Liabilities).
Step 3: Calculate Percentages
For each line item in the statement, calculate its percentage relative to the base figure for that year.
Derivation/Formula:
$ \text{Percentage of Item} = \frac{\text{Absolute Amount of the Item}}{\text{Absolute Amount of the Base Figure}} \times 100 $
Illustration 1. Prepare a Common-Size Statement of Profit and Loss from the following information.
| Particulars | 2019-20 ($\text{₹} \ $) | 2020-21 ($\text{₹} \ $) |
|---|---|---|
| Revenue from Operations | 10,00,000 | 12,50,000 |
| Other Incomes | 1,50,000 | 1,00,000 |
| Cost of Materials Consumed | 6,00,000 | 7,50,000 |
| Employee Benefit Expenses | 1,00,000 | 1,20,000 |
| Other Expenses | 50,000 | 80,000 |
Answer:
Common-Size Statement of Profit and Loss
for the years ended March 31, 2020 and 2021
| Particulars | Absolute Amounts ($\text{₹} \ $) | Percentage of Revenue from Operations (%) | ||
|---|---|---|---|---|
| 2019-20 | 2020-21 | 2019-20 | 2020-21 | |
| I. Revenue from Operations | 10,00,000 | 12,50,000 | 100.00 | 100.00 |
| II. Other Incomes | 1,50,000 | 1,00,000 | 15.00 | 8.00 |
| III. Total Revenue (I+II) | 11,50,000 | 13,50,000 | 115.00 | 108.00 |
| IV. Expenses: | ||||
| Cost of Materials Consumed | 6,00,000 | 7,50,000 | 60.00 | 60.00 |
| Employee Benefit Expenses | 1,00,000 | 1,20,000 | 10.00 | 9.60 |
| Other Expenses | 50,000 | 80,000 | 5.00 | 6.40 |
| Total Expenses | 7,50,000 | 9,50,000 | 75.00 | 76.00 |
| V. Profit before Tax (III-IV) | 4,00,000 | 4,00,000 | 40.00 | 32.00 |
Interpretation:
Although the absolute profit before tax remained the same at $\text{₹} \ 4,00,000$ in both years, the common-size statement reveals a decline in profitability. The profit margin (Profit before Tax as a percentage of Revenue from Operations) has decreased from 40% in 2019-20 to 32% in 2020-21. This is because the total expenses as a percentage of revenue increased from 75% to 76%, and other income as a percentage of revenue decreased from 15% to 8%.
Illustration 2. Prepare a Common-Size Balance Sheet of XRI Ltd. from the following information:
| Particulars | 2020 ($\text{₹} \ $) | 2021 ($\text{₹} \ $) |
|---|---|---|
| Equity and Liabilities | ||
| Share capital | 15,00,000 | 12,00,000 |
| Reserves and surplus | 5,00,000 | 5,00,000 |
| Long-term borrowings | 6,00,000 | 5,00,000 |
| Trade Payables | 15,50,000 | 10,50,000 |
| Total | 41,50,000 | 32,50,000 |
| Assets | ||
| Property, Plant and Equipment | 29,00,000 | 20,00,000 |
| Non-current investments | 10,00,000 | 10,00,000 |
| Inventories | 2,50,000 | 2,50,000 |
| Total | 41,50,000 | 32,50,000 |
Answer:
Common-Size Balance Sheet of XRI Co. Ltd.
as at March 31, 2020 and March 31, 2021
| Particulars | Absolute Amounts ($\text{₹} \ $) | Percentage of Total (%) | ||
|---|---|---|---|---|
| 2020 | 2021 | 2020 | 2021 | |
| I. Equity and Liabilities | ||||
| Share capital | 15,00,000 | 12,00,000 | 36.14 | 36.92 |
| Reserves and surplus | 5,00,000 | 5,00,000 | 12.05 | 15.38 |
| Long-term borrowings | 6,00,000 | 5,00,000 | 14.46 | 15.38 |
| Trade payables | 15,50,000 | 10,50,000 | 37.35 | 32.32 |
| Total Equity and Liabilities | 41,50,000 | 32,50,000 | 100.00 | 100.00 |
| II. Assets | ||||
| Property, Plant and Equipment | 29,00,000 | 20,00,000 | 69.88 | 61.54 |
| Non-current investments | 10,00,000 | 10,00,000 | 24.10 | 30.77 |
| Inventories | 2,50,000 | 2,50,000 | 6.02 | 7.69 |
| Total Assets | 41,50,000 | 32,50,000 | 100.00 | 100.00 |
Interpretation:
The common-size balance sheet reveals changes in the financial structure despite a decrease in the company's overall size (total assets decreased). In 2021, the company relied more on internal funds (Shareholders' funds increased from 48.19% to 52.30% of the total) and less on short-term credit (Trade Payables decreased from 37.35% to 32.32%). On the asset side, the proportion of Property, Plant and Equipment has decreased (from 69.88% to 61.54%), while the proportion of Non-current Investments and Inventories has increased, indicating a shift in the company's asset composition.
Limitations of Financial Analysis
While financial analysis is an extremely helpful and indispensable tool for determining the financial strengths and weaknesses of a firm, it is not a perfect science and is subject to several significant limitations. The analysis is entirely dependent on the information provided in the financial statements; therefore, it inherently suffers from all the limitations of those statements. An analyst must be acutely aware of these constraints to avoid drawing misleading or inaccurate conclusions.
Major Limitations of Financial Analysis
-
Ignores Price Level Changes (Based on Historical Cost): Financial statements are prepared based on the historical cost principle, which means assets are recorded at their original purchase price. Financial analysis, being based on these figures, does not account for changes in the price level due to inflation. This can severely distort the true picture of a firm's profitability and financial position. For example, a building purchased 20 years ago for ₹ 50 lakhs might be worth ₹ 5 crores today, but the analysis will be based on its much lower book value. This understates the true value of assets and can make profitability ratios (like Return on Assets) appear artificially high.
-
Can be Misleading Due to Changes in Accounting Procedures: The comparability of financial data is crucial for effective analysis. However, companies can choose between different acceptable accounting policies (e.g., changing the method of depreciation from Written Down Value to Straight Line Method, or the method of inventory valuation). If a company changes its accounting procedures, a comparison of its financial statements over different years becomes difficult and can be misleading unless the impact of these changes is fully understood and adjusted for. Without this knowledge, an analyst might misinterpret a change in profit as an operational improvement when it is merely the result of an accounting change.
-
It is Just a Study of Reports (Subject to "Window Dressing"): The analysis is only as good as the data it is based on. The accuracy and reliability of the analysis depend entirely on the accuracy of the data in the financial statements themselves. The practice of "window dressing"—where management manipulates financial figures to present a better-than-actual picture of the company's performance—can render the analysis useless. For instance, a company might delay necessary expenses to the next accounting period or offer huge discounts at year-end to inflate sales figures. An analysis of such manipulated data will lead to flawed conclusions.
-
Ignores Non-Monetary Aspects (Qualitative Factors): Financial analysis is purely quantitative and considers only information that can be expressed in monetary terms. It completely ignores crucial non-monetary or qualitative factors that have a significant impact on a firm's long-term success. These include the quality and integrity of the management team, employee morale and relations, brand reputation, customer loyalty, research and development capabilities, and the overall economic climate. An analysis based purely on numbers misses this vital context.
-
Does Not Reflect the Current Position (Historical Nature): Financial statements are historical documents. The Statement of Profit and Loss reports on a past period, and the Balance Sheet is a snapshot on a particular day that is already in the past. Therefore, financial analysis provides insights based on past performance, which is not always a reliable indicator of future results, especially in a rapidly changing business environment.
NCERT Questions Solution
Test your Understanding – I
Fill in the blanks with appropriate word(s):
Question 1. Analysis simply means ... data.
Answer:
Analysis simply means simplification of data.
Explanation: Financial analysis involves breaking down complex financial data into simpler, more manageable components. The process includes classifying, grouping, and rearranging data to highlight relationships and make it easier to understand.
Question 2. Interpretation means ... data.
Answer:
Interpretation means explaining the meaning and significance of the data.
Explanation: Interpretation is the step that follows analysis. It involves drawing conclusions and making judgments about the financial performance and position of a business based on the simplified (analyzed) data. It answers the "so what?" question about the numbers.
Question 3. Comparative analysis is also known as ... analysis.
Answer:
Comparative analysis is also known as horizontal analysis.
Explanation: In comparative analysis, financial data from two or more consecutive accounting periods are placed side-by-side to analyze the trend. Since the comparison moves across columns (from one year to the next), like reading along a horizontal line, it is called horizontal analysis.
Question 4. Common size analysis is also known as ... analysis.
Answer:
Common size analysis is also known as vertical analysis.
Explanation: In common size analysis, each item in a financial statement for a single period is expressed as a percentage of a common base figure from that same statement (e.g., Revenue from Operations for the P&L statement). Since the analysis moves up and down the items within a single column, it is known as vertical analysis.
Question 5. The analysis of actual movement of money inflow and outflow in an organisation is called ... analysis.
Answer:
The analysis of actual movement of money inflow and outflow in an organisation is called cash flow analysis.
Explanation: Cash flow analysis is specifically concerned with tracking the sources (inflows) and uses (outflows) of cash and cash equivalents over a period. The primary tool for this is the Cash Flow Statement, which categorizes these movements into operating, investing, and financing activities.
Do it yourself (Page No. 178)
Question. From the following particulars, prepare comparative statement of profit and loss of Narang Colours Ltd. for the year ended March 31, 2016 and 2017:
| Particulars | Note No. | 2016-17 | 2015-16 |
|---|---|---|---|
| 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 | 2016-17 | 2015-16 |
|---|---|---|
| 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 |
| Total | 2,66,000 | 3,02,000 |
Answer:
A Comparative Statement of Profit and Loss is a tool of financial analysis that shows the operating results of a business for two or more accounting periods side-by-side. It helps in identifying the trend and direction of performance by showing the absolute and percentage change in each line item.
Note: As per Schedule III of the Companies Act, 2013, Provision for Tax is shown as 'Tax Expense' after calculating 'Profit before tax'. Therefore, it has been excluded from 'Other Expenses' and shown separately in the statement below. The final profit figures provided in the question are inconsistent with the expense data; hence, the profit has been recalculated based on the given components.
Comparative Statement of Profit and Loss of Narang Colours Ltd.
for the years ended March 31, 2016 and 2017
| Particulars | 2015-16 (₹) | 2016-17 (₹) | Absolute Change (₹) | Percentage Change (%) |
|---|---|---|---|---|
| I. Revenue from Operations | 35,00,000 | 40,00,000 | 5,00,000 | 14.29 |
| II. Other Income | 50,000 | 50,000 | - | - |
| III. Total Revenue (I + II) | 35,50,000 | 40,50,000 | 5,00,000 | 14.08 |
| IV. Expenses: | ||||
| Cost of materials consumed | 18,00,000 | 15,00,000 | (3,00,000) | (16.67) |
| Changes in inventories | (15,000) | 10,000 | 25,000 | N/A |
| Employee benefit expenses | 2,40,000 | 2,40,000 | - | - |
| Depreciation and amortisation | 22,500 | 25,000 | 2,500 | 11.11 |
| Other expenses (Excluding tax) | 2,42,000 | 2,16,000 | (26,000) | (10.74) |
| Total Expenses | 22,89,500 | 19,91,000 | (2,98,500) | (13.04) |
| V. Profit before Tax (III - IV) | 12,60,500 | 20,59,000 | 7,98,500 | 63.35 |
| VI. Less: Tax Expense | 60,000 | 50,000 | (10,000) | (16.67) |
| VII. Profit after Tax (V - VI) | 12,00,500 | 20,09,000 | 8,08,500 | 67.35 |
Do it yourself (Page No. 181)
Question. From the Balance Sheets for the year ended March 31, 2016 and 2017, prepare the comparative Balance Sheet of Omega Chemicals Ltd.:
Rs. in Lakhs
| Particulars | Note No. | 2017 (Rs.) | 2016 (Rs.) |
|---|---|---|---|
| I. Equity and Liabilities | |||
| 1) Shareholders’ Fund | |||
| a) Share Capital | 5 | 10 | |
| b) Reserve and Surplus | 3 | 2 | |
| 2) Non-current Liabilities | |||
| Long-term Borrowings | 5 | 8 | |
| 3) Current Liabilities | |||
| Trade Payables | 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 |
Answer:
A Comparative Balance Sheet is a tool that shows the financial position of a business on different dates side-by-side. It facilitates comparison by showing the absolute increase or decrease and the percentage change for each item on the balance sheet.
Note: The figures for assets in the provided question appear to be swapped between the years 2016 and 2017, as the totals do not match the liabilities. The following solution has been prepared after correcting this apparent error to ensure the balance sheets for both years tally.
Comparative Balance Sheet of Omega Chemicals Ltd.
as at March 31, 2016 and 2017
(in Lakhs of Rs.)
| Particulars | 2016 (₹) | 2017 (₹) | Absolute Change (₹) | Percentage Change (%) |
|---|---|---|---|---|
| I. EQUITY AND LIABILITIES | ||||
| 1. Shareholders' Funds | ||||
| a) Share Capital | 10.00 | 5.00 | (5.00) | (50.00) |
| b) Reserves and Surplus | 2.00 | 3.00 | 1.00 | 50.00 |
| 2. Non-Current Liabilities | ||||
| Long-term Borrowings | 8.00 | 5.00 | (3.00) | (37.50) |
| 3. Current Liabilities | ||||
| Trade Payables | 4.00 | 2.00 | (2.00) | (50.00) |
| Total Equity and Liabilities | 24.00 | 15.00 | (9.00) | (37.50) |
| II. ASSETS | ||||
| 1. Non-Current Assets | ||||
| a) Fixed Assets - Tangible | 14.00 | 8.00 | (6.00) | (42.86) |
| b) Fixed Assets - Intangible | 3.00 | 2.00 | (1.00) | (33.33) |
| 2. Current Assets | ||||
| a) Inventories | 5.00 | 4.00 | (1.00) | (20.00) |
| b) Cash and Cash Equivalents | 2.00 | 1.00 | (1.00) | (50.00) |
| Total Assets | 24.00 | 15.00 | (9.00) | (37.50) |
Do it yourself (Page No. 185)
Question. Prepare common size balance sheet of Raj Co. Ltd. as at March 31, 2016 and March 31, 2017 from the given information:
| Particulars | 2017 | 2016 |
|---|---|---|
| I. Equity and Liabilities | ||
| 1. Shareholders fund | ||
| a) Share capital | 20,00,000 | 15,00,000 |
| b) Reserve and surplus | 3,00,000 | 4,00,000 |
| 2. Non-current liabilities | ||
| Long-term borrowings | 9,00,000 | 6,00,000 |
| 3. Current liabilities | ||
| 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 |
| Total | 35,00,000 | 27,00,000 |
Answer:
A Common Size Balance Sheet is a statement where each item of the balance sheet is expressed as a percentage of the total of assets (or total equity and liabilities). This form of vertical analysis helps in understanding the internal structure of the company's financial position and comparing it over different periods or with other companies.
Formula: $\text{Percentage} = (\frac{\text{Individual Item Amount}}{\text{Total Assets or Total Equity & Liabilities}}) \times 100$
Common Size Balance Sheet of Raj Co. Ltd.
as at March 31, 2016 and 2017
| Particulars | Absolute Amounts (₹) | Percentage of Total (%) | ||
|---|---|---|---|---|
| 2016 | 2017 | 2016 | 2017 | |
| I. EQUITY AND LIABILITIES | ||||
| 1. Shareholders' Funds | ||||
| a) Share Capital | 15,00,000 | 20,00,000 | 55.56 | 57.14 |
| b) Reserves and Surplus | 4,00,000 | 3,00,000 | 14.81 | 8.57 |
| 2. Non-Current Liabilities | ||||
| Long-term Borrowings | 6,00,000 | 9,00,000 | 22.22 | 25.71 |
| 3. Current Liabilities | ||||
| Trade Payables | 2,00,000 | 3,00,000 | 7.41 | 8.57 |
| Total Equity and Liabilities | 27,00,000 | 35,00,000 | 100.00 | 100.00 |
| II. ASSETS | ||||
| 1. Non-Current Assets | ||||
| a) Fixed Assets - Tangible | 15,00,000 | 20,00,000 | 55.56 | 57.14 |
| b) Fixed Assets - Intangible | 6,00,000 | 9,00,000 | 22.22 | 25.71 |
| 2. Current Assets | ||||
| a) Inventories | 4,00,000 | 3,00,000 | 14.81 | 8.57 |
| b) Cash and Cash Equivalents | 2,00,000 | 3,00,000 | 7.41 | 8.57 |
| Total Assets | 27,00,000 | 35,00,000 | 100.00 | 100.00 |
Test your Understanding – II
Choose the right answer :
Question 1. The financial statements of a business enterprise include:
(a) Balance sheet
(b) Statement of Profit and loss account
(c) Cash flow statement
(d) All the above
Answer:
The correct option is (d) All the above.
Explanation: As per Section 2(40) of the Companies Act, 2013, a complete set of financial statements includes the Balance Sheet, Statement of Profit and Loss, and the Cash Flow Statement, along with notes to accounts.
Question 2. The most commonly used tools for financial analysis are:
(a) Horizontal analysis
(b) Vertical analysis
(c) Ratio analysis
(d) All the above
Answer:
The correct option is (d) All the above.
Explanation: Horizontal analysis (comparative statements), vertical analysis (common-size statements), and ratio analysis are all widely used and important tools for analyzing a company's financial statements.
Question 3. An Annual Report is issued by a company to its:
(a) Directors
(b) Auditors
(c) Shareholders
(d) Management
Answer:
The correct option is (c) Shareholders.
Explanation: An annual report is a comprehensive report on a company's activities throughout the preceding year. It is primarily intended to give shareholders and other interested people information about the company's activities and financial performance.
Question 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
Answer:
The correct option is (a) At a point in time.
Explanation: A Balance Sheet is a snapshot of a company's financial health, showing its assets, liabilities, and equity on a specific date (e.g., "as at March 31, 2017"). It does not show transactions over a period, which is the function of the Statement of Profit and Loss.
Question 5. Comparative statements are also known as:
(a) Dynamic analysis
(b) Horizontal analysis
(c) Vertical analysis
(d) External analysis
Answer:
The correct option is (b) Horizontal analysis.
Explanation: Comparative statements place financial data for two or more periods side-by-side to analyze the trend. Since the comparison is made across columns from left to right (horizontally), it is known as horizontal analysis.
Test your Understanding – III
Question. 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.
Answer:
(a) True
Reason: As per the Companies Act, 2013, a complete set of financial statements includes the Balance Sheet, Statement of Profit and Loss, and a Cash Flow Statement.
(b) True
Reason: Comparative statements analyse financial data over two or more periods side-by-side, which is a form of horizontal (or trend) analysis.
(c) False
Reason: Common size statements are a tool of vertical analysis. However, ratio analysis is a separate and distinct tool of financial analysis, not a part of vertical analysis.
(d) False
Reason: Ratio analysis establishes relationships between various items or groups of items within the financial statements, not between the statements themselves. Some ratios use items from a single statement, while others use items from both.
(e) True
Reason: Ratio analysis is a universally accepted technique used to evaluate the financial performance (profitability, efficiency) and position (liquidity, solvency) of any business enterprise.
(f) False
Reason: Financial analysis is used by a wide variety of stakeholders, including management, shareholders, investors, government, employees, and researchers, not just creditors.
(g) True
Reason: The Statement of Profit and Loss summarises revenues and expenses for a specific accounting period to determine the profit or loss, thereby reflecting the enterprise's performance over that period.
(h) True
Reason: The primary purpose of financial analysis is to simplify and interpret financial data to provide insights that help users make informed economic decisions.
(i) False
Reason: A Cash Flow Statement is a component of the financial statements, not a tool for their analysis. The analysis of the cash flow statement is a tool, but the statement itself is part of the data being analysed.
(j) True
Reason: This is the definition of a common-size statement. For a balance sheet, the base is Total Assets, and for a statement of profit and loss, the base is Revenue from Operations.
Short Answers
Question 1. List the techniques of Financial Statement Analysis.
Answer:
The main techniques or tools of Financial Statement Analysis are:
Comparative Statements: Presenting financial statement data for two or more periods side-by-side to analyze trends. This is also known as horizontal analysis.
Common-Size Statements: Expressing each item in a financial statement as a percentage of a common base, such as total assets or total revenue. This is also known as vertical analysis.
Ratio Analysis: Calculating and interpreting various ratios to assess profitability, liquidity, solvency, and efficiency.
Trend Analysis: Analyzing the trend of key financial ratios or items over a number of years to forecast future performance.
Cash Flow Analysis: Analyzing the inflows and outflows of cash through a Cash Flow Statement to assess the liquidity and solvency of the enterprise.
Question 2. Distinguish between Vertical and Horizontal Analysis of financial data.
Answer:
The distinction between Vertical and Horizontal Analysis is as follows:
| Basis of Distinction | Horizontal Analysis | Vertical Analysis |
|---|---|---|
| Meaning | It is a method of analyzing financial statements by comparing data for two or more consecutive years. | It is a method of analyzing financial statements by establishing a relationship between various items of a single accounting period. |
| Tool Used | The primary tool is the Comparative Statement (Comparative Balance Sheet and P&L). | The primary tool is the Common-Size Statement (Common-Size Balance Sheet and P&L). |
| Purpose | Its purpose is to study the trend and direction of change in various items over time. | Its purpose is to study the proportional significance of each item relative to a common base within the same period. |
| Data Requirement | It requires financial data for multiple accounting periods. | It can be performed with the financial data of a single accounting period. |
| Format of Analysis | It presents absolute figures, absolute change, and percentage change side-by-side. | It presents absolute figures and their percentage to a common base side-by-side. |
Question 3. State the meaning of Analysis and Interpretation.
Answer:
Analysis and Interpretation are two distinct but interconnected steps in the process of financial statement analysis.
Analysis:
Financial analysis refers to the process of simplifying and systematically classifying the complex data presented in the financial statements. It involves breaking down the financial information into simpler, more manageable components and establishing relationships between them using various tools like ratio analysis, comparative statements, and common-size statements. The primary goal of analysis is to make the data understandable.
Interpretation:
Interpretation is the process of explaining the meaning and significance of the analyzed financial data. It is the art of drawing conclusions, making judgments, and forming opinions about the financial performance and position of the business. While analysis provides the "what", interpretation provides the "so what" and "why". It is the critical final step that translates the numbers into a meaningful narrative for decision-making.
Question 4. State the importance of Financial Analysis?
Answer:
Financial analysis is of immense importance as it converts complex financial data into meaningful information for decision-making by various stakeholders. Its key points of importance are:
Assessing Financial Health: It helps in evaluating a firm's liquidity (ability to meet short-term obligations) and solvency (ability to meet long-term obligations), thus providing a clear picture of its overall financial health.
Evaluating Profitability: It allows users to assess the earning capacity and operational efficiency of the business by analyzing profitability ratios and trends over time.
Facilitating Managerial Decisions: Management uses financial analysis to identify areas of strength and weakness, make informed decisions, exercise control over operations, and formulate future strategies.
Assisting Investors: It helps investors in making rational decisions about buying, holding, or selling a company's shares by providing insights into its performance and future prospects.
Guiding Creditors: It enables lenders and suppliers to determine the creditworthiness of a firm and its ability to repay debts, which is crucial for granting loans or extending credit.
Simplifying Complex Data: Financial analysis simplifies and summarizes a large volume of accounting data into a few key metrics and trends, making it easier for users to understand and interpret.
Question 5. What are Comparative Financial Statements?
Answer:
Comparative Financial Statements are statements that present the financial data of a business for two or more consecutive accounting periods in a side-by-side format. The primary purpose is to facilitate comparison and identify trends in the company's financial performance and position over time.
These statements typically show:
- Absolute figures for the current and previous periods.
- The absolute change in these figures (increase or decrease).
- The percentage change in these figures.
The two main types are the Comparative Balance Sheet and the Comparative Statement of Profit and Loss. They are a tool of horizontal analysis.
Question 6. What do you mean by Common Size Statements?
Answer:
Common Size Statements are financial statements in which each item is expressed as a percentage of a common base figure. This helps in understanding the proportional significance of each component within the financial statement and is useful for comparing companies of different sizes or for analysing the internal structure of a single company over time.
The key features are:
In a Common Size Balance Sheet, each asset is expressed as a percentage of Total Assets, and each item of equity and liability is expressed as a percentage of Total Equity and Liabilities.
In a Common Size Statement of Profit and Loss, each item of expense or income is expressed as a percentage of Revenue from Operations (or Net Sales).
They are a tool of vertical analysis.
Long Answers
Question 1. Describe the different techniques of financial analysis and explain the limitations of financial analysis.
Answer:
Techniques of Financial Analysis
Financial analysis uses various techniques to evaluate a company's financial performance and position. The principal techniques are:
Comparative Financial Statements: Also known as horizontal analysis, this technique involves comparing financial statement data for two or more consecutive periods. By showing the absolute and percentage changes, it helps in identifying the direction and trend of the business's performance.
Common-Size Financial Statements: Also known as vertical analysis, this technique expresses each line item of a financial statement as a percentage of a common base. For the Balance Sheet, the base is Total Assets; for the Statement of Profit & Loss, it is Revenue from Operations. It is useful for understanding the internal structure of the financial statements and for comparing companies of different sizes.
Ratio Analysis: This is a quantitative analysis of information contained in a company's financial statements. Ratios are calculated to evaluate various aspects of a company's operating and financial performance such as its liquidity, solvency, profitability, and efficiency.
Trend Analysis: This involves analyzing the trend of key financial items or ratios over a series of years (typically five or more). By selecting a base year and expressing subsequent years' figures as a percentage of the base year, analysts can spot significant long-term trends and patterns.
Cash Flow Analysis: This involves the analysis of the Cash Flow Statement, which shows the inflows and outflows of cash from operating, investing, and financing activities. It is a crucial tool for assessing the liquidity and solvency of an enterprise.
Limitations of Financial Analysis
While financial analysis is a powerful tool, it has several inherent limitations:
Historical Nature: Financial analysis is based on historical data from past financial statements. It does not provide a direct forecast of future performance, which may be influenced by different factors.
Ignores Qualitative Factors: The analysis is purely quantitative and ignores important non-monetary factors like the quality of management, employee morale, brand reputation, and industry conditions, which are critical to a company's success.
Affected by Accounting Policies and Judgements: The financial data itself is a product of accounting conventions and personal judgments (e.g., choice of depreciation method, inventory valuation). Different policies can lead to different results, making comparisons between firms difficult.
Impact of Price Level Changes: Financial statements do not account for inflation, which can distort the financial results. For example, profits may appear to be increasing, but in real terms (after adjusting for inflation), they might be declining.
Window Dressing: The analysis can be misleading if the underlying financial statements have been manipulated by the management to present a better-than-actual picture of the firm's financial health.
Lack of Standard Definitions: Some terms and ratios do not have universally accepted definitions (e.g., what constitutes 'operating profit'). This can lead to inconsistencies in analysis.
Question 2. Explain the usefulness of trend percentages in interpretation of financial performance of a company.
Answer:
Trend percentages, also known as index analysis, are a technique of financial analysis used to study the movement and direction of various financial items over a number of years. It involves selecting a base year and expressing the values of all items in subsequent years as a percentage of their value in the base year.
$\text{Trend Percentage} = \frac{\text{Current Year's Value}}{\text{Base Year's Value}} \times 100$
The usefulness of trend percentages in interpreting financial performance is significant, as explained below:
Long-Term Perspective: Unlike comparative statements that typically compare only two years, trend analysis provides a long-term view of a company's performance, usually over five to ten years. This helps in identifying more stable and reliable trends rather than being misled by short-term fluctuations.
Identifying Direction of Change: By looking at the trend percentages, an analyst can easily see whether key items like sales, costs, and profits are increasing, decreasing, or remaining stagnant over the long run. This helps in assessing the growth trajectory and stability of the company.
Comparative Analysis of Different Items: Trend percentages allow for a meaningful comparison of the relative change in different items. For example, an analyst can compare the trend percentage of sales with the trend percentage of the cost of goods sold. If the cost percentage is rising faster than the sales percentage, it indicates a decline in gross profit margin and potential inefficiency.
Forecasting and Planning: The study of past trends provides a solid basis for forecasting future performance. Management can use this information for better planning, budgeting, and strategic decision-making.
Highlighting Problem Areas: A negative or stagnant trend in a crucial area (like a declining trend in sales or a rapidly increasing trend in operating expenses) can quickly highlight problem areas that require management's attention.
In conclusion, trend analysis is a powerful tool that transforms absolute financial data into a dynamic picture of a company's performance over time, making it invaluable for interpretation and forecasting.
Question 3. What is the importance of comparative statements? Illustrate your answer with particular reference to comparative income statement.
Answer:
Importance of Comparative Statements
Comparative financial statements are statements that present the financial data of a business for two or more consecutive accounting periods in a side-by-side format. They are a tool of horizontal analysis and are highly important for the following reasons:
Makes Data Comparable: By presenting figures for multiple periods together, they make it easy to compare the company's performance and position over time.
Identifies Trends: They help in identifying the direction and trend of key financial items. For example, a user can see if sales are consistently growing or if expenses are rising at an alarming rate.
Highlights Strengths and Weaknesses: Significant changes, both positive and negative, are highlighted through the calculation of absolute and percentage changes. This helps management and other stakeholders to pinpoint areas of strength and weakness.
Facilitates Forecasting: The trend revealed by comparative statements provides a basis for forecasting future performance and financial position.
Aids in Decision Making: The clear insights provided by these statements help all stakeholders—management, investors, creditors—in making more informed and rational economic decisions.
Illustration with a Comparative Income Statement
A Comparative Income Statement shows the operating results for two or more periods. It is particularly useful for assessing the trend in a company's profitability. Consider the following example:
Comparative Income Statement (Example)
| Particulars | Year 1 (₹) | Year 2 (₹) | Absolute Change (₹) | Percentage Change (%) |
|---|---|---|---|---|
| Revenue from Operations | 10,00,000 | 12,00,000 | 2,00,000 | 20.0% |
| Less: Cost of Goods Sold | (6,00,000) | (7,80,000) | (1,80,000) | 30.0% |
| Gross Profit | 4,00,000 | 4,20,000 | 20,000 | 5.0% |
Interpretation from the example:
Positive Trend: Revenue from operations has increased by 20%, which is a positive sign of growth.
Negative Trend: However, the Cost of Goods Sold has increased by 30%, which is much faster than the increase in sales. This is a red flag.
Impact on Profitability: As a result, even though the absolute Gross Profit has increased by $\textsf{₹ } \ 20,000$, its rate of growth is only 5%. This indicates a decline in the gross profit margin and suggests that the company's efficiency in managing its production or procurement costs has worsened. This insight would not be as apparent without the comparative format.
Question 4. What do you understand by analysis and interpretation of financial statements? Discuss its importance.
Answer:
Analysis and Interpretation of Financial Statements
Analysis of financial statements refers to the process of systematically classifying and simplifying the vast amount of data contained in the financial statements (Balance Sheet, Statement of Profit and Loss, etc.). It involves establishing meaningful relationships between different components of the statements through the use of tools like comparative statements, common-size statements, and ratio analysis. The primary goal of analysis is to break down complex information into a more understandable format.
Interpretation of financial statements is the subsequent step. It involves explaining the meaning and significance of the analyzed data. Interpretation is the art of drawing conclusions and making judgments about the financial performance (profitability) and financial position (solvency and liquidity) of a business. While analysis presents the "what," interpretation explains the "why" and "so what" behind the numbers.
Importance of Financial Analysis and Interpretation
The analysis and interpretation of financial statements are crucial for various stakeholders as it transforms raw data into actionable intelligence. Its importance is as follows:
Managerial Decision-Making: It is vital for the management to measure the firm's performance, identify areas of inefficiency, and formulate strategies for the future. It helps in controlling costs, managing assets effectively, and making sound financial plans.
Investor Decisions: For shareholders and potential investors, it helps in assessing the profitability and safety of their investment. By analyzing trends and ratios, they can decide whether to invest, hold, or sell their shares.
Credit Analysis: Lenders, banks, and suppliers use financial analysis to evaluate the creditworthiness of a company. It helps them assess the firm's ability to meet its short-term and long-term debt obligations, which is crucial for making lending and credit decisions.
Performance Evaluation: It provides a clear basis for evaluating the operating efficiency and financial health of the business. By comparing the firm's performance with its past performance (intra-firm comparison) and with other firms in the same industry (inter-firm comparison), a comprehensive evaluation is possible.
Forecasting and Budgeting: The analysis of historical financial data helps in identifying trends, which are essential for forecasting future earnings and financial position. This, in turn, aids in the preparation of budgets and financial plans.
Question 5. Explain how common size statements are prepared giving an example.
Answer:
Common-size statements are a tool of vertical analysis where each item in a financial statement is expressed as a percentage of a common base figure from that same statement. This converts the statement into a "common-size" format, making it easy to see the proportional significance of each item and to compare companies of different sizes.
Preparation of Common-Size Statements
The preparation involves the following steps:
1. For a Common-Size Balance Sheet:
- The total of the Assets side (or the total of Equity and Liabilities) is taken as the base, representing 100%.
- Each individual asset (e.g., Land, Machinery, Debtors) is then expressed as a percentage of the total assets.
- Similarly, each individual item of equity and liability (e.g., Share Capital, Creditors) is expressed as a percentage of the total equity and liabilities.
2. For a Common-Size Income Statement (Statement of Profit and Loss):
- The figure for 'Revenue from Operations' (or Net Sales) is taken as the base, representing 100%.
- Every other item on the statement, such as the cost of goods sold, operating expenses, and net profit, is then expressed as a percentage of the Revenue from Operations.
Example: Common-Size Income Statement
Let's assume a company has the following data:
- Revenue from Operations: $\textsf{₹ } \ 20,00,000$
- Cost of Goods Sold: $\textsf{₹ } \ 12,00,000$
- Operating Expenses: $\textsf{₹ } \ 4,00,000$
Common-Size Income Statement
| Particulars | Absolute Amount (₹) | Percentage of Revenue (%) |
|---|---|---|
| Revenue from Operations | 20,00,000 | 100.0 |
| Less: Cost of Goods Sold | (12,00,000) | (60.0) |
| Gross Profit | 8,00,000 | 40.0 |
| Less: Operating Expenses | (4,00,000) | (20.0) |
| Net Profit | 4,00,000 | 20.0 |
Calculation for Percentages:
- Cost of Goods Sold % = ($\frac{12,00,000}{20,00,000}) \times 100 = 60\%$
- Net Profit % = ($\frac{4,00,000}{20,00,000}) \times 100 = 20\%$
This format clearly shows that for every $\textsf{₹ } \ 100$ of sales, the company spends $\textsf{₹ } \ 60$ on the cost of goods and $\textsf{₹ } \ 20$ on operating expenses, leaving a net profit of $\textsf{₹ } \ 20$.
Numerical Questions
Question 1. Following are the balance sheets of Alpha Ltd., as at March 31, 2016 and 2017. You are required to prepare Comparative Balance Sheet.
| Particulars | March 31, 2016 (Rs.) | March 31, 2017 (Rs.) |
|---|---|---|
| I. Equity and Liabilities | ||
| 1. Shareholders' Funds | ||
| (a) Share Capital | 2,00,000 | 4,00,000 |
| (b) Reserve & Surplus | 1,00,000 | 1,50,000 |
| 2. Noncurrent Liabilities | ||
| (a) Long Term Borrowings | 2,00,000 | 3,00,000 |
| 3.Current Liabilities | ||
| (a) Short term borrowings | 50,000 | 70,000 |
| (b) Trade Payables | 30,000 | 60,000 |
| (c) Other Current Liabilities | 20,000 | 10,000 |
| (d) Short Terms Provisions | 20,000 | 20,000 |
| Total | 6,20,000 | 10,10,000 |
| II. Assets | ||
| 1. Non-Current Assets | ||
| (a) Fixed Assets | 2,00,000 | 5,00,000 |
| (b) Non-Current Investments | 1,00,000 | 1,25,000 |
| 2. Current Assets | ||
| (a) Current Investments | 60,000 | 80,000 |
| (b) Inventories | 1,35,000 | 1,55,000 |
| (c) Trade Receivables | 60,000 | 90,000 |
| (d) Cash and Cash Equivalents | 25,000 | 10,000 |
| (e) Short term Loans & Advances | 40,000 | 60,000 |
| Total | 6,20,000 | 10,20,000 |
(Note: There is a totaling error in the liabilities side of 2017 in the question, which has been corrected to Rs. 10,20,000)
Answer:
Comparative Balance Sheet of Alpha Ltd.
as at March 31, 2016 and 2017
| Particulars | 2016 ($\textsf{₹ }$) | 2017 ($\textsf{₹ }$) | Absolute Change ($\textsf{₹ }$) | Percentage Change (%) |
|---|---|---|---|---|
| I. Equity and Liabilities | ||||
| Share Capital | 2,00,000 | 4,00,000 | 2,00,000 | 100.00 |
| Reserve & Surplus | 1,00,000 | 1,50,000 | 50,000 | 50.00 |
| Long Term Borrowings | 2,00,000 | 3,00,000 | 1,00,000 | 50.00 |
| Short term borrowings | 50,000 | 70,000 | 20,000 | 40.00 |
| Trade Payables | 30,000 | 60,000 | 30,000 | 100.00 |
| Other Current Liabilities | 20,000 | 10,000 | (10,000) | (50.00) |
| Short Terms Provisions | 20,000 | 20,000 | - | - |
| Total | 6,20,000 | 10,10,000 | 3,90,000 | 62.90 |
| II. Assets | ||||
| Fixed Assets | 2,00,000 | 5,00,000 | 3,00,000 | 150.00 |
| Non-Current Investments | 1,00,000 | 1,25,000 | 25,000 | 25.00 |
| Current Investments | 60,000 | 80,000 | 20,000 | 33.33 |
| Inventories | 1,35,000 | 1,55,000 | 20,000 | 14.81 |
| Trade Receivables | 60,000 | 90,000 | 30,000 | 50.00 |
| Cash and Cash Equivalents | 25,000 | 10,000 | (15,000) | (60.00) |
| Short term Loans & Advances | 40,000 | 60,000 | 20,000 | 50.00 |
| Total | 6,20,000 | 10,20,000 | 4,00,000 | 64.52 |
Question 2. Following are the Balance Sheets of Beta Ltd., as at March 31, 2016 and 2017.
| Particulars | March 31, 2016 (Rs.) | March 31, 2017 (Rs.) |
|---|---|---|
| I. Equity and Liabilities | ||
| 1. Shareholders’ Funds | ||
| (a) Share Capital | 4,00,000 | 3,00,000 |
| (b) Reserves and surplus | 1,50,000 | 1,00,000 |
| 2. Non-Current Liabilities | ||
| (a) Long term Loan from IDBI | 3,00,000 | 1,00,000 |
| 3. Current Liabilities | ||
| (a) Short term borrowings | 70,000 | 50,000 |
| (b) Trade payables | 60,000 | 30,000 |
| (c) Other current liabilities | 1,10,000 | 1,00,000 |
| (d) Short term provisions | 10,000 | 20,000 |
| Total | 11,00,000 | 7,00,000 |
| II. Assets | ||
| 1. Non-Current Assets | ||
| (a) Fixed Assets | 4,00,000 | 2,20,000 |
| (b) Non-current Investments | 2,25,000 | 1,00,000 |
| 2. Current Assets | ||
| (a) Current Investments | 80,000 | 60,000 |
| (b) Inventories | 1,05,000 | 90,000 |
| (c) Trade Receivables | 90,000 | 60,000 |
| (d) Cash and Cash Equivalents | 1,00,000 | 85,000 |
| (e) Short term loans & Advances | 1,00,000 | 85,000 |
| Total | 11,00,000 | 7,00,000 |
Prepare comparative Balance Sheet.
Answer:
Comparative Balance Sheet of Beta Ltd.
as at March 31, 2016 and 2017
| Particulars | 2016 ($\textsf{₹ }$) | 2017 ($\textsf{₹ }$) | Absolute Change ($\textsf{₹ }$) | Percentage Change (%) |
|---|---|---|---|---|
| I. Equity and Liabilities | ||||
| Share Capital | 4,00,000 | 3,00,000 | (1,00,000) | (25.00) |
| Reserves and surplus | 1,50,000 | 1,00,000 | (50,000) | (33.33) |
| Long term Loan from IDBI | 3,00,000 | 1,00,000 | (2,00,000) | (66.67) |
| Short term borrowings | 70,000 | 50,000 | (20,000) | (28.57) |
| Trade payables | 60,000 | 30,000 | (30,000) | (50.00) |
| Other current liabilities | 1,10,000 | 1,00,000 | (10,000) | (9.09) |
| Short term provisions | 10,000 | 20,000 | 10,000 | 100.00 |
| Total | 11,00,000 | 7,00,000 | (4,00,000) | (36.36) |
| II. Assets | ||||
| Fixed Assets | 4,00,000 | 2,20,000 | (1,80,000) | (45.00) |
| Non-current Investments | 2,25,000 | 1,00,000 | (1,25,000) | (55.56) |
| Current Investments | 80,000 | 60,000 | (20,000) | (25.00) |
| Inventories | 1,05,000 | 90,000 | (15,000) | (14.29) |
| Trade Receivables | 90,000 | 60,000 | (30,000) | (33.33) |
| Cash and Cash Equivalents | 1,00,000 | 85,000 | (15,000) | (15.00) |
| Short term loans & Advances | 1,00,000 | 85,000 | (15,000) | (15.00) |
| Total | 11,00,000 | 7,00,000 | (4,00,000) | (36.36) |
Question 3. Prepare Comparative Statement of profit and loss from the following information.
| Particulars | 2015-16 (Rs.) | 2016-17 (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 |
| Return inward | 8,000 | 4,000 |
| Gross profit | (30,000) | 90,000 |
| Carriage outward | 20,000 | 10,000 |
| Machinery | 3,00,000 | 2,00,000 |
| 10% depreciation on machinery | 10,000 | 5,000 |
| 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% |
Answer:
Comparative Statement of Profit and Loss
| Particulars | 2015-16 ($\textsf{₹ }$) | 2016-17 ($\textsf{₹ }$) | Absolute Change ($\textsf{₹ }$) | Percentage Change (%) |
|---|---|---|---|---|
| Revenue from operations (Sales - Return) | 92,000 | 1,06,000 | 14,000 | 15.22 |
| Other Incomes (Profit on Sale) | 20,000 | 10,000 | (10,000) | (50.00) |
| Total Revenue | 1,12,000 | 1,16,000 | 4,000 | 3.57 |
| Cost of Materials Consumed | 80,000 | 1,10,000 | 30,000 | 37.50 |
| Employee Benefit Expenses (Wages) | 10,000 | 5,000 | (5,000) | (50.00) |
| Finance Costs (Interest) | 22,000 | 21,000 | (1,000) | (4.55) |
| Depreciation | 10,000 | 5,000 | (5,000) | (50.00) |
| Other Expenses | 1,30,000 | 80,000 | (50,000) | (38.46) |
| Total Expenses | 2,52,000 | 2,21,000 | (31,000) | (12.30) |
| Profit before Tax | (1,40,000) | (1,05,000) | 35,000 | (25.00) |
| Less: Tax | - | - | - | - |
| Profit after Tax | (1,40,000) | (1,05,000) | 35,000 | (25.00) |
Question 4. Prepare Comparative Statement of Profit and Loss from the following information:
| Particulars | 2015-16 (Rs.) | 2016-17 (Rs.) |
|---|---|---|
| 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 purchase) | 6,000 (out of cash purchase) |
| Closing stock | 150% of opening stock | 1,00,000 |
| Credit purchases | 1,50,000 | 150% of cash purchase |
| Cash purchases | 80% of credit purchases | 40,000 |
| 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% |
Answer:
Comparative Statement of Profit and Loss
| Particulars | 2015-16 ($\textsf{₹ }$) | 2016-17 ($\textsf{₹ }$) | Absolute Change ($\textsf{₹ }$) | Percentage Change (%) |
|---|---|---|---|---|
| Revenue from operations (Sales) | 9,60,000 | 4,50,000 | (5,10,000) | (53.13) |
| Other Incomes (Profit on Sale) | 10,000 | 20,000 | 10,000 | 100.00 |
| Total Revenue | 9,70,000 | 4,70,000 | (5,00,000) | (51.55) |
| Cost of Materials Consumed | 2,66,000 | 94,000 | (1,72,000) | (64.66) |
| Change in Inventories | (15,000) | (40,000) | (25,000) | 166.67 |
| Finance Costs (Interest) | 25,000 | 2,00,000 | 1,75,000 | 700.00 |
| Depreciation | 20,000 | 20,000 | - | - |
| Other Expenses | 65,000 | 1,20,000 | 55,000 | 84.62 |
| Total Expenses | 3,61,000 | 3,94,000 | 33,000 | 9.14 |
| Profit before Tax | 6,09,000 | 76,000 | (5,33,000) | (87.52) |
| Less: Tax | 3,04,500 | 30,400 | (2,74,100) | (90.02) |
| Profit after Tax | 3,04,500 | 45,600 | (2,58,900) | (85.02) |
Question 5. Prepare a Common size statement of profit and loss of Shefali Ltd. with the help of following information:
| Particulars | 2015-16 (Rs.) | 2016-17 (Rs.) |
|---|---|---|
| Revenue from operations | 6,00,000 | 8,00,000 |
| Indirect expense | 25% of gross profit | 25% of gross profit |
| Cost of revenue from operations | 4,28,000 | 7,28,000 |
| Other incomes | 10,000 | 12,000 |
| Income tax | 30% | 30% |
Answer:
Common Size Statement of Profit and Loss of Shefali Ltd.
| Particulars | 2015-16 ($\textsf{₹ }$) | % of Revenue | 2016-17 ($\textsf{₹ }$) | % of Revenue |
|---|---|---|---|---|
| Revenue from Operations | 6,00,000 | 100.00 | 8,00,000 | 100.00 |
| Other Incomes | 10,000 | 1.67 | 12,000 | 1.50 |
| Total Revenue | 6,10,000 | 101.67 | 8,12,000 | 101.50 |
| Cost of Revenue from Operations | 4,28,000 | 71.33 | 7,28,000 | 91.00 |
| Indirect Expenses | 43,000 | 7.17 | 18,000 | 2.25 |
| Total Expenses | 4,71,000 | 78.50 | 7,46,000 | 93.25 |
| Profit before Tax | 1,39,000 | 23.17 | 66,000 | 8.25 |
| Less: Tax (30%) | 41,700 | 6.95 | 19,800 | 2.48 |
| Profit after Tax | 97,300 | 16.22 | 46,200 | 5.77 |
Question 6. Prepare a Common Size balance sheet from the following balance sheet of Aditya Ltd., and Anjali Ltd.:
| Particulars | Aditya Ltd. (Rs.) | Anjali Ltd. (Rs.) |
|---|---|---|
| I. Equity and Liabilities | ||
| 1. Shareholder’s Funds | ||
| a) Equity share capital | 6,00,000 | 8,00,000 |
| b) Reserves and surplus | 3,00,000 | 2,50,000 |
| 2. Current liabilities | 1,00,000 | 1,50,000 |
| Total | 10,00,000 | 12,00,000 |
| II. Assets | ||
| 1. Non current assets | ||
| a) Fixed assets | 4,00,000 | 7,00,000 |
| 2. Current assets | 6,00,000 | 5,00,000 |
| Total | 10,00,000 | 12,00,000 |
Answer:
Common Size Balance Sheet
| Particulars | Aditya Ltd. ($\textsf{₹ }$) | % of Total | Anjali Ltd. ($\textsf{₹ }$) | % of Total |
|---|---|---|---|---|
| I. Equity and Liabilities | ||||
| Equity Share Capital | 6,00,000 | 60.00 | 8,00,000 | 66.67 |
| Reserves and Surplus | 3,00,000 | 30.00 | 2,50,000 | 20.83 |
| Current Liabilities | 1,00,000 | 10.00 | 1,50,000 | 12.50 |
| Total | 10,00,000 | 100.00 | 12,00,000 | 100.00 |
| II. Assets | ||||
| Fixed Assets | 4,00,000 | 40.00 | 7,00,000 | 58.33 |
| Current Assets | 6,00,000 | 60.00 | 5,00,000 | 41.67 |
| Total | 10,00,000 | 100.00 | 12,00,000 | 100.00 |