Analysis of Financial Statements
Short Answer Practice Questions
- 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.
| 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. |
- 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.
- 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.
- Absolute figures for two periods.
- Absolute change (Increase/Decrease).
- Percentage change (Increase/Decrease).
- 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).
Analysis of Financial Statements
Long Answer Questions
Techniques of Financial Analysis
- 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.
- 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).
- 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).
- Ratio Analysis: It establishes a relationship between various accounting figures (e.g., Current Assets and Current Liabilities) to assess liquidity, solvency, and profitability.
- 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.
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.
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 Ops | 10,00,000 | 15,00,000 | 5,00,000 | 50% |
| II. Expenses | 6,00,000 | 10,00,000 | 4,00,000 | 66.67% |
| III. Profit (I – II) | 4,00,000 | 5,00,000 | 1,00,000 | 25% |
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.
- 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.
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 Ops | 10,00,000 | 12,00,000 | 100% | 100% |
| II. Cost of Goods Sold | 6,00,000 | 7,80,000 | 60% | 65% |
| III. Gross Profit | 4,00,000 | 4,20,000 | 40% | 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.
Analysis of Financial Statements
Numerical Questions 1-6
| 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 Capital | 2,00,000 | 4,00,000 | 2,00,000 | 100.00% |
| (b) Reserves & Surplus | 1,00,000 | 1,50,000 | 50,000 | 50.00% |
| 2. Non-Current Liabilities | ||||
| (a) Long Term Borrowings | 2,00,000 | 3,00,000 | 1,00,000 | 50.00% |
| 3. Current Liabilities | ||||
| (a) Short Term Borrowings | 50,000 | 70,000 | 20,000 | 40.00% |
| (b) Trade Payables | 30,000 | 60,000 | 30,000 | 100.00% |
| (c) Other Current Liabilities | 20,000 | 10,000 | (10,000) | (50.00%) |
| (d) Short Term Provisions | 20,000 | 20,000 | – | 0.00% |
| Total | 6,20,000 | 10,10,000 | 3,90,000 | 62.90% |
| II. ASSETS | ||||
| 1. Non-Current Assets | ||||
| (a) Fixed Assets | 2,00,000 | 5,00,000 | 3,00,000 | 150.00% |
| (b) Non-Current Investments | 1,00,000 | 1,25,000 | 25,000 | 25.00% |
| 2. Current Assets | ||||
| (a) Current Investments | 60,000 | 80,000 | 20,000 | 33.33% |
| (b) Inventories | 1,35,000 | 1,55,000 | 20,000 | 14.81% |
| (c) Trade Receivables | 60,000 | 90,000 | 30,000 | 50.00% |
| (d) Cash & Cash Equivalents | 25,000 | 10,000 | (15,000) | (60.00%) |
| (e) Short Term Loans & Adv. | 40,000 | 60,000 | 20,000 | 50.00% |
| Total | 6,20,000 | 10,20,000 | 4,00,000 | 64.52% |
| Particulars | 2016 (A) | 2017 (B) | Abs. Change | % Change |
|---|---|---|---|---|
| I. EQUITY AND LIABILITIES | ||||
| Share Capital | 4,00,000 | 3,00,000 | (1,00,000) | (25.00%) |
| Reserves & Surplus | 1,50,000 | 1,00,000 | (50,000) | (33.33%) |
| Long Term Borrowings (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 & Cash Equivalents | 1,00,000 | 85,000 | (15,000) | (15.00%) |
| Short Term Loans & Adv. | 1,00,000 | 85,000 | (15,000) | (15.00%) |
| Total | 11,00,000 | 7,00,000 | (4,00,000) | (36.36%) |
| Particulars | 2015-16 | 2016-17 | Abs. Change | % Change |
|---|---|---|---|---|
| REVENUE | ||||
| Revenue from Operations (Sales)* | 2,00,000 | 2,00,000 | – | 0.00% |
| Other Income (Profit on Sale) | 20,000 | 10,000 | (10,000) | (50.00%) |
| Total Revenue (A) | 2,20,000 | 2,10,000 | (10,000) | (4.55%) |
| EXPENSES | ||||
| Cost of Materials Consumed** | 1,92,000 | 76,000 | (1,16,000) | (60.42%) |
| Employee Benefit Exp (Wages) | 10,000 | 5,000 | (5,000) | (50.00%) |
| Finance Costs (Interest)*** | 40,000 | 30,000 | (10,000) | (25.00%) |
| Depreciation | 10,000 | 5,000 | (5,000) | (50.00%) |
| Other Expenses**** | 1,80,000 | 1,00,000 | (80,000) | (44.44%) |
| Total Expenses (B) | 4,32,000 | 2,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%) |
* 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.
| Particulars | 2015-16 | 2016-17 | Abs. Change | % Change |
|---|---|---|---|---|
| I. Revenue from Operations | 9,56,000 | 4,44,000 | (5,12,000) | (53.56%) |
| II. Other Income | 10,000 | 20,000 | 10,000 | 100.00% |
| III. Total Revenue | 9,66,000 | 4,64,000 | (5,02,000) | (51.97%) |
| IV. Expenses | ||||
| Purchase of Stock | 2,30,000 | 1,00,000 | (1,30,000) | (56.52%) |
| Change in Inventory | (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 | – | 0.00% |
| Other Expenses | 75,000 | 1,40,000 | 65,000 | 86.67% |
| Total Expenses | 3,35,000 | 4,20,000 | 85,000 | 25.37% |
| V. Profit Before Tax | 6,31,000 | 44,000 | (5,87,000) | (93.03%) |
| Less: Tax | 3,15,500 | 17,600 | (2,97,900) | (94.42%) |
| VI. Profit After Tax | 3,15,500 | 26,400 | (2,89,100) | (91.63%) |
| Particulars | 2015-16 (Abs) |
% of Rev | 2016-17 (Abs) |
% of Rev |
|---|---|---|---|---|
| I. Revenue From Operations | 6,00,000 | 100.00% | 8,00,000 | 100.00% |
| II. Other Income | 10,000 | 1.67% | 12,000 | 1.50% |
| III. Total Revenue | 6,10,000 | 101.67% | 8,12,000 | 101.50% |
| IV. Expenses | ||||
| Cost of Revenue (COGS) | 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% |
| V. Profit Before Tax | 1,39,000 | 23.17% | 66,000 | 8.25% |
| Less: Tax (30%) | 41,700 | 6.95% | 19,800 | 2.48% |
| VI. Profit After Tax | 97,300 | 16.22% | 46,200 | 5.78% |
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.
| Particulars | Aditya Ltd (Abs) |
% of Total | Anjali Ltd (Abs) |
% of Total |
|---|---|---|---|---|
| I. EQUITY AND LIABILITIES | ||||
| 1. Shareholders’ Funds | ||||
| (a) Share Capital | 6,00,000 | 60.00% | 8,00,000 | 66.67% |
| (b) Reserves & Surplus | 3,00,000 | 30.00% | 2,50,000 | 20.83% |
| 2. 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 | ||||
| 1. Non-Current Assets | ||||
| (a) Fixed Assets | 4,00,000 | 40.00% | 7,00,000 | 58.33% |
| 2. Current Assets | 6,00,000 | 60.00% | 5,00,000 | 41.67% |
| Total | 10,00,000 | 100.00% | 12,00,000 | 100.00% |