In: Accounting
The summarized financial statements of Indira, a limited liability company, at 31 October 2012 and 31 October 2013 are given below:
Balance sheet
Notes |
2012 |
2013 |
|||
GHS |
GHS |
GHS |
GHS |
||
Non-current assets(net book value) |
1,2,3 |
1,000,000 |
1,800,000 |
||
Current Assets |
|||||
Inventories |
600,000 |
1,600,000 |
|||
receivables |
1,270,000 |
1,800,000 |
|||
cash |
140,000 |
2,010,000 |
3,400,000 |
||
3,010,000 |
5,200,000 |
||||
Capital and reserve |
|||||
Ordinary share capital |
4 |
500,000 |
600,000 |
||
Share premium account |
4 |
420,000 |
820,000 |
||
Revaluation reserve |
5 |
300,000 |
|||
Accumulated profits |
920,000 |
1,340,000 |
1,080,000 |
2,200,000 |
|
1,840,000 |
2,800,000 |
||||
Current Liabilities |
|||||
Bank Overdraft |
260,000 |
||||
Income Tax |
120,000 |
40,000 |
|||
Trade Payables |
1,050,000 |
1,170,000 |
2,100,000 |
2,400,000 |
|
3,010,000 |
5,200,000 |
Income Statement
Notes |
2012 |
2013 |
|
GHS |
GHS |
||
Sales revenue(all on credit) |
8,400,000 |
9,000,000 |
|
Cost of sales |
6 |
(6,300,000) |
(7,200,000) |
Gross Profit |
2,100,000 |
1,800,000 |
|
Operating expenses |
(1,500,000) |
(1,600,000) |
|
Profit before tax |
600,000 |
200,000 |
|
Income tax expense |
(120,000) |
(40,000) |
|
Profit for the year |
480,000 |
160,000 |
Notes
(1) On 1 November 2012 office equipment that had cost GHS240, 000 with a net book value of GHS80, 000, was sold for GHS30, 000.
(2) The purchase of new non-current assets took place near the end of the year.
(3) The depreciation charge for the year ended 31 October 2013 was GHS120, 000.
(4) The ordinary share issue was on 31 October 2013.
(5) Some of the non-current assets were revalued upwards by GHS300, 000 on 1 November 2012.
(6) Cost of sales was made up as follows:
2012 |
2013 |
|
GHS |
GHS |
|
Opening inventory |
500,000 |
600,000 |
purchases |
6,400,000 |
8,200,000 |
6,900,000 |
8,800,000 |
|
Closing inventory |
(600,000) |
(1,600,000) |
Cost of sales |
6,300,000 |
7,200,000 |
Prepare a cash flow statement for Indira for the year ended 31 October 2013, using the format in IAS 7 Cash Flow Statements.
Cash flow statement for the year 31st October 2013
Particulars | amount (GHS) |
A. CASH FLOW FROM OPERATING ACTIVITIES | |
Net profit before Tax | 200000 |
+Depreciation for the year(Non cash Expenses) | 120000 |
+Loss on sale on NCA(Non operating) (WN-1) | 50000 |
- increase in inventory | (1000000) |
-Increase in receivable | (530000) |
+ increase in Trade payable | 1050000 |
-income tax paid(WN-2) | (120000) |
Total cash flow from operating activities | (230000) |
B.CASH FLOW FROM INVESTING ACTIVITIES | |
Proceeds from sale of Non current assets | 30000 |
Purchase of Non current assets(WN-1) | (700000) |
Total cash flow from investing activities | (670000) |
C. CASH FLOW FROM FINANCING ACTIVITIES | |
Proceeds from issue of shares | 100000 |
Proceed from share premium | 400000 |
Bank over draft receipt | 260000 |
Total cash flow from financing activities | 760000 |
Total cash flow during the year(A+B+C) | (140000) |
+ OPENING CASH BALANCE | 140000 |
Closing cash balance(31 oct 2013) | nil |
# Working note(WN-1)(Non current Assets)
Opening balance(1st nov 2012) | 1000000 | sale of NCA on 01, NOV 2012 | 80000 |
Revaluation during year | 300000 | Depreciation charged | 120000 |
New NCA purchased(Balancing figure) | 700000 | closing balance | 1800000 |
Total | 2000000 | Total | 2000000 |
# Working Note(WN-2) INCOME TAX PAID
Paid(Balancing figure) | 120000 | Opening balance (1 nov 2012) | 120000 |
Closing balance (31.oct.2013) | 40000 | Provision made during year | 40000 |
Total | 160000 | Total | 160000 |