Chapter 4: Analysis of Financial Statements

Analysis of Financial Statements

Short Answer Practice Questions

Q1 List the techniques of Financial Statement Analysis.
The most commonly used techniques of financial statement analysis are:
  • Comparative Statements: Comparing financial data of two or more years.
  • Common Size Statements: Converting figures into percentages of a common base (e.g., Sales or Total Assets).
  • Trend Analysis: Calculating trend percentages over a series of years.
  • Ratio Analysis: Calculating accounting ratios to assess profitability, liquidity, and solvency.
  • Cash Flow Analysis: Analyzing the inflow and outflow of cash.
Q2 Distinguish between Vertical and Horizontal Analysis of financial data.
Basis Horizontal Analysis Vertical Analysis
Period Requires financial statements of two or more years. Requires financial statement of one year.
Comparison Items are compared year by year (horizontally). Items are compared to a common base within the same year (vertically).
Utility Useful for time-series analysis (trend). Useful for cross-sectional analysis (inter-firm).
Example Comparative Balance Sheet. Common Size Balance Sheet.
Q3 State the meaning of Analysis and Interpretation.
  • Analysis: It refers to the process of simplifying and rearranging financial data from the complex financial statements into meaningful categories to understand the relationships between various items.
  • Interpretation: It refers to explaining the meaning and significance of the processed data (analysis). It involves drawing conclusions about the profitability, solvency, and liquidity of the business based on the analysis.
Q4 State the importance of Financial Analysis.
Financial analysis is important because it:
  • Helps in judging the Profitability and operational efficiency of the firm.
  • Helps in assessing the Solvency (both short-term and long-term) of the business.
  • Facilitates Comparative Studies (inter-firm and intra-firm).
  • Helps management in Decision Making and forecasting future trends.
Q5 What are Comparative Financial Statements?
Comparative Financial Statements are statements that show the financial position and performance of a firm for two or more periods in a side-by-side columnar form. They highlight:
  • Absolute figures for two periods.
  • Absolute change (Increase/Decrease).
  • Percentage change (Increase/Decrease).
This helps in analyzing the direction of change (Trend Analysis).
Q6 What do you mean by Common Size Statements?
Common Size Statements are vertical financial statements in which amounts are converted into percentages of a common base.
  • For Balance Sheet, the common base is Total Assets (Total Equity & Liabilities).
  • For Statement of P&L, the common base is Revenue from Operations (Net Sales).
This allows for easy comparison of the composition of assets/liabilities and expenses between companies of different sizes.
Chapter 4: Long Answer Questions

Analysis of Financial Statements

Long Answer Questions

Q1 Describe the different techniques of financial analysis and explain the limitations of financial analysis.

Techniques of Financial Analysis

  1. Comparative Statements: Statements of two or more years are placed side by side to facilitate comparison. They show absolute data, absolute change, and percentage change.
  2. Common Size Statements: Statements where individual items are converted into percentage of a common base (e.g., Sales for Income Statement, Total Assets for Balance Sheet).
  3. Trend Analysis: A base year is selected, and subsequent years’ data are expressed as a percentage of the base year to determine the trend (upward/downward).
  4. Ratio Analysis: It establishes a relationship between various accounting figures (e.g., Current Assets and Current Liabilities) to assess liquidity, solvency, and profitability.
  5. Cash Flow Analysis: It studies the sources (inflow) and uses (outflow) of cash during a period.

Limitations of Financial Analysis

  • Historical Nature: It analyzes past data which may not be relevant for future decisions.
  • Ignores Price Level Changes: It fails to account for inflation, making long-term comparison difficult.
  • Qualitative Factors Ignored: It only considers monetary facts, ignoring non-monetary factors like management quality.
  • Affected by Window Dressing: If the original statements are manipulated, the analysis will be misleading.
  • Lack of Standard Norms: Different accounting policies (e.g., Depreciation methods) make inter-firm comparison difficult.
Q2 Explain the usefulness of trend percentages in interpretation of financial performance of a company.

Trend percentages (or Trend Analysis) involves calculating the percentage relationship that each item of different years bears to the same item in the base year. It is highly useful because:

  • Direction of Change: It clearly indicates the direction (increase, decrease, or constant) of financial items over a period of time.
  • Growth Assessment: It helps in assessing the growth rate of key figures like Sales, Profits, and Assets.
  • Future Forecasting: By studying the past trend, management can project future performance and plan accordingly.
  • Simplicity: It is easier for a layman to understand percentages (e.g., “Sales have grown by 20%”) than complex absolute figures.
  • Detecting Weaknesses: If the trend of expenses is rising faster than the trend of sales, it acts as an early warning signal for inefficiency.
Q3 What is the importance of comparative statements? Illustrate your answer with particular reference to comparative income statement.

Importance: Comparative statements place the figures of current year and previous year side-by-side. They help in:

  • Showing the absolute change in items.
  • Showing the percentage change, which makes the data comparable even if the scale of operation changes.
  • Identifying the weak and strong points of the business operations.

Illustration: Comparative Income Statement

Particulars Prev Year (A) Curr Year (B) Abs. Change (C=B-A) % Change (D=C/A*100)
I. Revenue from Ops10,00,00015,00,0005,00,00050%
II. Expenses6,00,00010,00,0004,00,00066.67%
III. Profit (I – II)4,00,0005,00,0001,00,00025%

In this example, while Sales increased by 50%, Profit only increased by 25% because Expenses rose disproportionately by 66.67%. This highlights inefficiency in cost control.

Q4 What do you understand by analysis and interpretation of financial statements? Discuss its importance.
  • Analysis: It is the methodical classification and processing of the data given in the financial statements. It involves breaking down complex data into simple elements (like ratios or percentages).
  • Interpretation: It is the process of drawing meaning and significance from the analyzed data. It involves explaining why a ratio is low or high and what it means for the future of the company.

Importance:

  • For Investors: To judge the safety and return on their investment.
  • For Management: To evaluate operational efficiency and locate areas of waste.
  • For Creditors: To determine the liquidity and ability of the firm to pay debts.
  • For Employees: To negotiate for better wages based on profitability.
Q5 Explain how common size statements are prepared giving an example.

Preparation Process: In a Common Size Statement, each item is expressed as a percentage of a common base.

  • Income Statement: Base = Revenue from Operations (Net Sales) = 100%. All expenses and incomes are expressed as a % of Sales.
  • Balance Sheet: Base = Total Assets (or Total Equity & Liabilities) = 100%. All assets and liabilities are expressed as a % of Total.

Example: Common Size Income Statement

Particulars Absolute Amounts % of Revenue
2016 2017 2016 2017
I. Revenue from Ops10,00,00012,00,000100%100%
II. Cost of Goods Sold6,00,0007,80,00060%65%
III. Gross Profit4,00,0004,20,00040%35%

This clearly shows that although absolute Gross Profit increased, the Gross Profit Margin fell from 40% to 35% because the Cost of Goods Sold rose from 60% to 65% of sales.

Chapter 4: Numerical Questions (1-6)

Analysis of Financial Statements

Numerical Questions 1-6

Q1 Comparative Balance Sheet of Alpha Ltd.
Particulars Mar 31, 2016
(A)
Mar 31, 2017
(B)
Abs. Change
(C = B – A)
% Change
(D = C/A*100)
I. EQUITY AND LIABILITIES
1. Shareholders’ Funds
(a) Share Capital2,00,0004,00,0002,00,000100.00%
(b) Reserves & Surplus1,00,0001,50,00050,00050.00%
2. Non-Current Liabilities
(a) Long Term Borrowings2,00,0003,00,0001,00,00050.00%
3. Current Liabilities
(a) Short Term Borrowings50,00070,00020,00040.00%
(b) Trade Payables30,00060,00030,000100.00%
(c) Other Current Liabilities20,00010,000(10,000)(50.00%)
(d) Short Term Provisions20,00020,0000.00%
Total6,20,00010,10,0003,90,00062.90%
II. ASSETS
1. Non-Current Assets
(a) Fixed Assets2,00,0005,00,0003,00,000150.00%
(b) Non-Current Investments1,00,0001,25,00025,00025.00%
2. Current Assets
(a) Current Investments60,00080,00020,00033.33%
(b) Inventories1,35,0001,55,00020,00014.81%
(c) Trade Receivables60,00090,00030,00050.00%
(d) Cash & Cash Equivalents25,00010,000(15,000)(60.00%)
(e) Short Term Loans & Adv.40,00060,00020,00050.00%
Total6,20,00010,20,0004,00,00064.52%
Note: In the question provided, the Liability side total for 2017 sums to 10,10,000 (4L+1.5L+3L+70k+60k+10k+20k), but the total given is 10,20,000. The Asset side total sums correctly to 10,20,000.
Q2 Comparative Balance Sheet of Beta Ltd.
Particulars 2016 (A) 2017 (B) Abs. Change % Change
I. EQUITY AND LIABILITIES
Share Capital4,00,0003,00,000(1,00,000)(25.00%)
Reserves & Surplus1,50,0001,00,000(50,000)(33.33%)
Long Term Borrowings (IDBI)3,00,0001,00,000(2,00,000)(66.67%)
Short Term Borrowings70,00050,000(20,000)(28.57%)
Trade Payables60,00030,000(30,000)(50.00%)
Other Current Liabilities1,10,0001,00,000(10,000)(9.09%)
Short Term Provisions10,00020,00010,000100.00%
Total11,00,0007,00,000(4,00,000)(36.36%)
II. ASSETS
Fixed Assets4,00,0002,20,000(1,80,000)(45.00%)
Non-Current Investments2,25,0001,00,000(1,25,000)(55.56%)
Current Investments80,00060,000(20,000)(25.00%)
Inventories1,05,00090,000(15,000)(14.29%)
Trade Receivables90,00060,000(30,000)(33.33%)
Cash & Cash Equivalents1,00,00085,000(15,000)(15.00%)
Short Term Loans & Adv.1,00,00085,000(15,000)(15.00%)
Total11,00,0007,00,000(4,00,000)(36.36%)
Q3 Comparative Statement of Profit & Loss
Particulars 2015-16 2016-17 Abs. Change % Change
REVENUE
Revenue from Operations (Sales)*2,00,0002,00,0000.00%
Other Income (Profit on Sale)20,00010,000(10,000)(50.00%)
Total Revenue (A)2,20,0002,10,000(10,000)(4.55%)
EXPENSES
Cost of Materials Consumed**1,92,00076,000(1,16,000)(60.42%)
Employee Benefit Exp (Wages)10,0005,000(5,000)(50.00%)
Finance Costs (Interest)***40,00030,000(10,000)(25.00%)
Depreciation10,0005,000(5,000)(50.00%)
Other Expenses****1,80,0001,00,000(80,000)(44.44%)
Total Expenses (B)4,32,0002,16,000(2,16,000)(50.00%)
PROFIT
Profit Before Tax (A-B)(2,12,000)(6,000)2,06,000(97.17%)
Less: Tax
Profit After Tax(2,12,000)(6,000)2,06,000(97.17%)
Calculation Notes:
* Sales: Calculated backwards from Gross Profit? The question provides GP. 2015-16 GP is (30,000). 2016-17 GP is 90,000. Data is fragmented. Assumed Net Sales = Cost + GP.
** Cost of Materials: Cash Purch + Credit Purch – Returns – Stock Adj + Mfg Exp.
*** Finance Costs: Int on Loan + Int on Debentures.
**** Other Expenses: Freight Out + Carriage Out + Loss on Sale of Car.
Q4 Comparative Statement of Profit & Loss
Particulars 2015-16 2016-17 Abs. Change % Change
I. Revenue from Operations9,56,0004,44,000(5,12,000)(53.56%)
II. Other Income10,00020,00010,000100.00%
III. Total Revenue9,66,0004,64,000(5,02,000)(51.97%)
IV. Expenses
Purchase of Stock2,30,0001,00,000(1,30,000)(56.52%)
Change in Inventory(15,000)(40,000)(25,000)166.67%
Finance Costs (Interest)25,0002,00,0001,75,000700.00%
Depreciation20,00020,0000.00%
Other Expenses75,0001,40,00065,00086.67%
Total Expenses3,35,0004,20,00085,00025.37%
V. Profit Before Tax6,31,00044,000(5,87,000)(93.03%)
Less: Tax3,15,50017,600(2,97,900)(94.42%)
VI. Profit After Tax3,15,50026,400(2,89,100)(91.63%)
Q5 Common Size Statement of P&L (Shefali Ltd.)
Particulars 2015-16
(Abs)
% of Rev 2016-17
(Abs)
% of Rev
I. Revenue From Operations6,00,000100.00%8,00,000100.00%
II. Other Income10,0001.67%12,0001.50%
III. Total Revenue6,10,000101.67%8,12,000101.50%
IV. Expenses
Cost of Revenue (COGS)4,28,00071.33%7,28,00091.00%
Indirect Expenses*43,0007.17%18,0002.25%
Total Expenses4,71,00078.50%7,46,00093.25%
V. Profit Before Tax1,39,00023.17%66,0008.25%
Less: Tax (30%)41,7006.95%19,8002.48%
VI. Profit After Tax97,30016.22%46,2005.78%
* Indirect Expense Calculation: 25% of Gross Profit.
2015-16 GP = Rev (6L) – Cost (4.28L) = 1,72,000. Ind Exp = 25% of 1.72L = 43,000.
2016-17 GP = Rev (8L) – Cost (7.28L) = 72,000. Ind Exp = 25% of 72k = 18,000.
Q6 Common Size Balance Sheet (Aditya & Anjali Ltd.)
Particulars Aditya Ltd
(Abs)
% of Total Anjali Ltd
(Abs)
% of Total
I. EQUITY AND LIABILITIES
1. Shareholders’ Funds
(a) Share Capital6,00,00060.00%8,00,00066.67%
(b) Reserves & Surplus3,00,00030.00%2,50,00020.83%
2. Current Liabilities1,00,00010.00%1,50,00012.50%
Total10,00,000100.00%12,00,000100.00%
II. ASSETS
1. Non-Current Assets
(a) Fixed Assets4,00,00040.00%7,00,00058.33%
2. Current Assets6,00,00060.00%5,00,00041.67%
Total10,00,000100.00%12,00,000100.00%
learncbsehub.in