Advertisements
Advertisements
Question
You are required to prepare a Cash-Flow Statement (as per AS-3)
for the year 2016-17 from the following Balance Sheet.
Balance Sheet of Honesty Ltd.
As at 31st March, 2016 and 31st March, 2017
I | Particulars | Note No. | 31.03.2017 |
31.03.2017 |
1. |
EQUITY AND LIABILITIES |
1. |
14,00,000 5,00,000
|
10,00,000 4,00,000
|
2. | Non-Current Liabilities Long Term Borrowing (10% Debentures) |
5,00,000 | 1,40,000 | |
3. | Current Liabilities (a) Short Term Borrowings (Bank Overdraft) (b) Trade Payables (Creditors) (c) Short Term Provisions |
20,000 1,00,000 60,000 |
30,000 60,000 30,000 |
|
TOTAL | 25,80,000 | 16,60,000 | ||
II 1. | ASSETS Non-Current Assets Fixed Assets (i) Tangible (ii) Intangible (Goodwill) |
2. |
16,00,000 1,40,000 |
9,00,000 2,00,000 |
2. | Current Assets (a) Inventories (b) Trade Receivables (c) Cash and Bank Balances (Cash at Bank) |
2,50,000 5,00,000 90,000 |
2,00,000 3,00,000 60,000 |
|
TOTAL | 25,80,000 | 16,60,000 |
Notes to Accounts:
Particulars | 31.03.2017 | 31.03.2016 |
1. Short term provisions provision for taxation |
60,000 | 30,000 |
2. Fixed Assets (Tangible) Plant and Machinery Less Accumulated Depreciation |
17,60,000 (1,60,000) |
10,00,000 (1,00,000) |
16,00,000 | 9,00,000 |
During the year 2016-17:
(i) A part of the machine, costing Rs. 50,000, accumulated depreciation thereon being Rs. 20,000, was sold for
Rs.18,000.
(ii) Tax paid Rs. 20,000.
(iii) Interest of Rs. 50,000 paid on Debentures.
Solution
Working Note 1.
Accumulated Depreciation A/c
Particulars | Amount | Particulars | Amount |
To P/M | 20,000 | By Bal b/d | 1,00,000 |
To Bal c/d | 1,60,000 | By Depreciation | 80,000 |
1,80,000 | 1,80,000 |
Working Note 2.
Provision for Taxation A/c
Particulars | Amount | Particulars | Amount |
To Cash | 20,000 | By Bal b/d | 30,000 |
To Bal c/d | 60,000 | By Statement of P/L | 50,000 |
80,000 | 80,000 |
Working Note 3.
Plant and Machinery A/c
Particulars | Amount | Particulars | Amount |
To Cash | 10,00,000 | By Acc. Depreciation | 20,000 |
To Bal c/d | 8,10,000 | By Statement of P/L | 18,000 |
By Loss on sale | 12,000 | ||
By Bal c/d | 17,60,000 | ||
18,10,000 | 18,10,000 |
Working Note 4.
Particulars | Rs. |
Net Profit for the year | 1,00,000 |
Add provision for Tax | 50,000 |
Net Profit before Tax | 1,50,000 |
Cash Flow Statement of Honesty Ltd.
for the year ending 31.03.2
I | Particular | Rs. | Rs. | Rs. |
Cash Flows from operating activities | ||||
Net Profit before Tax | 1,50,000 | |||
Add non-operating/non-cash expenses | 60,000 | |||
Goodwill written off | 80,000 | |||
Depreciation P/M | 12,000 | |||
Loss on sale of P/M | 50,000 | |||
Interest on Debentures | ||||
Net Operating Profit before working capital charges | 3,52,000 | |||
Add Trade Payables Less Inventory Less Trade Receivable |
40,000 (50,000) (2,00,000) |
(2,10,000) |
||
Cash Flow from operating activities before tax paid Less Tax Paid |
1,42,000 (20,000) |
|||
Cash Flow from operating activities | 1,22,000 | |||
II | Cash Flows from Investing Activities | 18,000 | ||
Sale of P/M | (8,10,000) | |||
Purchase of P/M | ||||
Cash used in Inv. Activities | (7,92,000) | |||
III | Cash Flows from Financing Activities | |||
Issue of Share Capital | 4,00,000 | |||
Issue of Debentures | 3,60,000 | |||
Interest on Deb. paid | (50,000) | |||
Bank overdraft repaid | (10,000) | |||
Cash Flow from Financing Activities | ||||
Net increase in Cash as per I, II and III Add Op Cash & Cash Equivalent |
7,00,000 30,000 |
|||
Cash at Bank | 60,000 | |||
Closing Cash and Cash Equivalent 90,000 | 90,000 | |||
90,000 | 90,000 |
APPEARS IN
RELATED QUESTIONS
While preparing the Cash Flow Statement of Alka Ltd. 'dividend paid' was shown as an operating
activity by the accountant of the company. Was he correct in doing so? Give reason.
The accountant of 'Nav Jeevan Limited' while preparing Cash Flow Statement added the proposed
dividend of the current year to net profit while calculating cash flow from operating activities. Was he correct in doing so? Give reason.
Net increase in working capital other than cash and cash equivalents will increase, decrease or not change cash flow from operating activities. Give reason in support of your answer.
From the following Balance Sheet of Vijay Ltd. as on 31-3-2009 and 31-3-2010 prepare a Cash Flow Statement.
Liabilities |
31-3-2009 Rs |
31-3-2010 Rs |
Assets |
31-3-2009 Rs |
31-3-2010 Rs |
Share Capital |
45,000 |
65,000 |
Fixed Assets |
46,700 |
83,000 |
General Reserve |
15,000 |
27,500 |
Stock |
11,000 |
13,000 |
Profit and Loss Account |
10,000 |
15,000 |
Debtors |
18,000 |
19,500 |
Trade Creditors |
8,700 |
11,000 |
Cash |
2,000 |
2,500 |
|
|
|
Preliminary Expenses |
1,000 |
500 |
|
78,700 |
1,18,500 |
|
78,700 |
1,18,500 |
|
|
|
|
|
|
Additional Information:
(i) Depreciation on Fixed assets for the year 2009-2010 was Rs 14,700
(ii) An interim dividend Rs 7,000 has been paid to the shareholders during the year.
List any two investing activities which result into outflow of cash.
What is the object of preparing a Cash Flow Statements?
The important objectives for preparing Cash Flow Statement are as follows.
- It helps to ascertain the gross inflows and outflows of cash and cash equivalents from various activities.
- Secondly, Cash Flow Statement helps in analysing various reasons responsible for change in the cash balances during an accounting year.
From the following Balance Sheets of B.C.R. Ltd as on 31-3-2010 and 31-3-2011.
Prepare a Cash Flow Statements:
Balance Sheets of B.C.R. Ltd. as on 31.3.2010 and 31.3.2011 |
|||||
Liabilities |
31-3-2010 Rs |
31-3-2011 Rs |
Assets |
31-3-2010 Rs |
31-3-2011 Rs |
Equity Shares Capital Profit and Loss Account Bank Loan Proposed Dividend Provision for tax Creditors |
5,00,000
2,00,000
1,00,000 50,000 30,000 55,000 |
7,00,000
3,50,000
50,000 70,000 50,000 52,000 |
Patents Equipment Investment Debtors Stock Bank |
1,00,000 5,00,000 – 80,000 55,000 2,00,000 |
95,000 5,00,000 1,00,000 1,30,000 3,00,000 |
|
|
||||
9,35,000 |
12,72,000 |
|
9,35,000 |
12,72,000 |
|
|
|
|
Additional Information:
During the year Equipment costing Rs 1,00,000 was purchases. Loss on sale of Equipment amounted to Rs 12,000. Rs 18,000 deprecation charged on Equipment.
Anand Ltd., arrived at a net income of Rs 5,00,000 for the year ended March 31, 2017. Depreciation for the year was Rs 2,00,000. There was a profit of Rs 50,000 on assets sold which was transferred to Statement of profit and Loss account. Trade Receivables increased during the year Rs 40,000 and Trade Payables also increased by Rs 60,000. Compute the cash flow operating activities by the indirect approach.
From the following information, prepare cash flow statement:
Particulars | Note No. | 31st March 2015 (Rs) |
31st March 2014 (Rs) |
I) Equity and Liabilities | |||
1. Shareholders’ Funds |
|||
a) Share capital |
7,00,000 | 5,00,000 | |
b) Reserves and surplus |
4,70,000 | 2,50,000 | |
2. Non-current Liabilities |
|||
(8% Debentures) |
4,00,000 | 6,00,000 | |
3. Current Liabilities |
|||
a) Trade payables |
9,00,000 | 6,00,000 | |
Total | 24,70,000 | 19,50,000 | |
II) Assets | |||
1. Non-current assets |
|||
a) Fixed assets |
|||
i) Tangible |
7,00,000 | 5,00,000 | |
ii) Intangible-Goodwill |
1,70,000 | 2,50,000 | |
2. Current assets |
|||
a) Inventories |
6,00,000 | 5,00,000 | |
b) Trade Receivables |
6,00,000 | 4,00,000 | |
c) Cash and cash equivalents |
4,00,000 | 3,00,000 | |
Total | 24,70,000 | 19,50,000 |
Additional Information:
Depreciation Charge on Plant amount to Rs. 80,000.
Cash from Operating Activities will decrease due to: