Following are the balance sheets of Alpha Ltd., as at March 31, 2016 and 2017. You are required to prepare Comparative Balance Sheet.
Comparative Balance Sheet of Alpha Ltd. as at March 31, 2016 and 2017
| Particulars | March 31, 2016 (Rs.) | March 31, 2017 (Rs.) | Absolute Change (Rs.) | Percentage Change (%) |
|---|---|---|---|---|
| I. Equity and Liabilities | ||||
| 1. Shareholders' Funds | ||||
| (a) Share Capital | 2,00,000 | 4,00,000 | 2,00,000 | 100.00 |
| (b) Reserve & Surplus | 1,00,000 | 1,50,000 | 50,000 | 50.00 |
| 2. Noncurrent 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 Terms Provisions | 20,000 | 20,000 | 0 | 0.00 |
| Total | 6,20,000 | 10,20,000 | 4,00,000 | 64.52 |
| II. Assets | ||||
| Total Assets (Balancing Figure) | 6,20,000 | 10,20,000 | 4,00,000 | 64.52 |
Note: The context provided does not list specific Asset items. Total Assets are taken equal to Total Equity and Liabilities.
Explanation
A Comparative Balance Sheet presents the financial position of a company for two or more periods side by side, showing the absolute change and percentage change to analyze trends. In this solution, the Absolute Change is calculated as (2017 Figure - 2016 Figure), and the Percentage Change is calculated as (Absolute Change / 2016 Figure) × 100. Since the provided context lists the Liabilities side in detail but cuts off the Assets section, the Total Assets figure is derived by equating it to the Total Equity and Liabilities (Balance Sheet equation), ensuring the statement balances.
Solution Steps
Step 1: Calculate Absolute Change for each item by subtracting the 2016 figure from the 2017 figure (e.g., Share Capital: 4,00,000 - 2,00,000 = 2,00,000).
Step 2: Calculate Percentage Change using the formula: (Absolute Change / 2016 Figure) × 100 (e.g., Share Capital: (2,00,000 / 2,00,000) × 100 = 100%).
Step 3: Sum the liabilities to find the Total for both years (2016: 6,20,000; 2017: 10,20,000).
Step 4: Compute Total change and percentage (4,00,000 / 6,20, = 64.52%).
Step 5: Present the data in the prescribed Comparative Balance Sheet format. As specific asset details were not provided in the context, Total Assets are shown as a balancing figure equal to Total Liabilities.