Tuesday, February 27, 2018

AHSEC - Class 12: Analysis of Financial Statements Practical Problems

Analysis of Financial Statements Practical Problems
Q.1. From the following Balance Sheet as at 31st March, 2012 and 2013, prepare Comparative  and Common Size Balance Sheet:
Particulars
2012 (Rs.)
2013 (Rs.)
I. EQUITY AND LIABILITIES
1.       Shareholder’s Funds
a)      Share Capital
b)      Reserve and Surplus
2.       Non-Current Liabilities
Long-term Borrowings (12% Debentures)
3.       Current Liabilities (Trade Payables)

7,50,000
4,50,000

7,50,000
3,00,000

15,00,000
3,00,000

12,00,000
6,00,000
Total
22,50,000
36,00,000
II. ASSETS
1.       Non-Current Assets
Fixed Assets
2.       Current Assets

15,00,000
7,50,000

22,50,000
13,50,000
Total
22,50,000
36,00,000
[Percentage Change: Share Capital 100%; Reserves (33.33%); Loan 60%; Current Liabilities 100%; Fixed Assets 50%; Current Assets 80%]

Q.2. From the following Balance Sheets as at 31at March, 2012 and 2013, prepare Comparative and Common size Balance Sheet:
Particulars
2012 (Rs.)
2013 (Rs.)
I. EQUITY AND LIABILITIES
1.       Shareholder’s Funds
a)      Share Capital
b)      Reserve and Surplus
2.       Non-Current Liabilities  - Long-term Borrowings (12% Loan)
3.       Current Liabilities
a)      Short-term Borrowings
b)      Trade Payables
c)       Short-term Provisions

7,50,000
4,50,000
7,50,000
1,75,000
1,00,000
25,000

15,00,000
3,00,000
12,00,000
3,50,000
2,00,000
50,000
Total
22,50,000
36,00,000
II. ASSETS
1.       Non-Current Assets
Fixed Assets (Tangible)
2.       Current Assets
a)      Inventories
b)      Trade Receivables
c)       Cash and Cash Equivalents

15,00,000

2,50,000
4,50,000
50,000

22,50,000

4,50,000
8,00,000
1,00,000
Total
22,50,000
36,00,000
[Percentage change: Share Capital 100%; Reserves (33.33%); Loan 60%; Current Liabilities: Short-term Borrowings 100%; Trade Payables 100%; Short-term Provisions 100%; Current Assets 80%; Fixed Assets 50%; Total 60%]
Q.3. Prepare Comparative and common size Income Statement from the following Statement of Profit and Loss:
Particulars
2012 (Rs.)
2013 (Rs.)
I. Income
Revenue from Operations (Sales)

3,00,000

3,50,000
II. Expenses
Purchase of Stock-in-Trade
Changes in Inventories of Stock-in-Trade
Employees Benefit Expenses
Other Expenses

1,80,000
20,000
15,000
5,000

2,10,000
15,000
17,500
7,500
Total
2,20,000
2,50,000
III. Net Profit (I – II)
80,000
1,00,000
Q.4. Prepare Comparative Income Statement from the following Statement of Profit and Loss:

Particulars
2012 (Rs.)
2013 (Rs.)
I. Income
Revenue from Operations (Sales)

2,50,000

3,00,000
II. Expenses
Cost of Materials Consumed
Changes in Inventories of WIP and Finished Goods
Employees Benefit Expenses (Wages)
Other Expenses

1,00,000
5,000
25,000
20,000

1,20,000
(2,000)
30,000
22,000
Total
1,50,000
1,70,000
III. Net Profit (I – II)
1,00,000
1,30,000