Advertisements
Advertisements
Question
From the following Balance Sheets of Tiger Super Steel Ltd., prepare Cash Flow Statement:
Balance Sheet of Tiger Super Steel Ltd.
as at 31st March 2014 and 31st March 2017
Particulars | Note No. | March 31, 2017 (Rs) |
March 31, 2016 (Rs) |
I) Equity and Liabilities | |||
1. Shareholders’ Funds |
|||
a) Share capital |
1 | 1,40,000 | 1,20,000 |
b) Reserves and surplus |
2 | 22,800 | 15,200 |
2. Current Liabilities |
|||
a) Trade payables |
3 | 21,200 | 14,000 |
b) Other current liabilities |
4 | 2,400 | 3,200 |
c) Short-term provisions |
5 | 28,400 | 22,400 |
Total | 2,14,800 | 1,74,800 | |
II) Assets | |||
1. Non-Current Assets |
|||
a) Fixed assets |
|||
i) Tangible assets |
6 | 96,400 | 76,000 |
ii) Intangible assets |
18,800 | 24,000 | |
b) Non-current investments |
14,000 | 4,000 | |
2. Current Assets |
|||
a) Inventories |
31,200 | 34,000 | |
b) Trade receivables |
43,200 | 30,000 | |
c) Cash and Cash Equivalents |
11,200 | 6,800 | |
Total | 2,14,800 | 1,74,800 |
Notes to accounts:
2017 |
2016 |
|
1. Share Capital |
||
Equity share capital |
1,20,000 |
80,000 |
10% Preference share capital |
20,000 |
40,000 |
1,40,000 |
1,20,000 |
|
2. Reserves and surplus |
||
General reserve |
12,000 |
8,000 |
Balance in statement of profit and loss |
10,800 |
7,200 |
22,800 |
15,200 |
|
3. Trade payables |
||
Bills payable |
21,200 |
14,000 |
4. Other current liabilities |
||
Outstanding expenses |
2,400 |
3,200 |
5. Short-term provisions |
||
Provision for taxation |
12,800 |
11,200 |
Proposed dividend |
15,600 |
11,200 |
28,400 |
22,400 |
|
6. Tangible assets |
||
Land and building |
20,000 |
40,000 |
Plant |
76,400 |
36,000 |
96,400 |
76,000 |
Additional Information:
Depreciation Charge on Land & Building Rs 20,000, and Plant Rs 10,000 during the year.
Solution
Cash Flow Statement of Tiger Super Steels Ltd
|
Particulars |
Amount Rs |
Amount Rs |
||
A. |
Cash Flow from Operating Activities |
|
|
||
|
Profit as per the Balance Sheet (10,800 –7,200) |
3,600 |
|
||
|
General Reserve |
4,000 |
|
||
|
Proposed Dividend |
15,600 |
|
||
|
Provision for Taxation |
12,800 |
|
||
|
Net Profit before Taxation and Extraordinary |
|
36,000 |
||
|
Items to be added: |
|
|
||
|
|
Depreciation on Land and Building |
20,000 |
|
|
|
|
Depreciation on Plant |
10,000 |
|
|
|
|
Goodwill written off |
5,200 |
35,200 |
|
|
Operating Profit before Working Capital changes |
|
71,200 |
||
|
|
Add: |
Increase in Current Liabilities |
|
|
|
|
|
Bills Payable |
7,200 |
|
|
|
Add: |
Decrease in Current Assets |
|
|
|
|
|
Inventories |
2,800 |
10,000 |
|
|
|
|
|
81,200 |
|
|
Less: |
Increase in Current Assets |
|
|
|
|
|
Trade Receivables |
(13,200) |
|
|
|
Less: |
Decrease in Current Liabilities |
|
|
|
|
|
Outstanding Expenses |
(800) |
(14,000) |
|
Cash Generated from Operating Activities |
|
67,200 |
||
|
|
Less: |
Income Tax paid |
|
(11,200) |
|
Net Cash from Operating Activities |
|
56,000 |
||
B. |
Cash Flow from Investing Activities |
|
|
||
|
|
Purchases of Plant |
|
(40,400) |
|
|
|
Purchases of Investment |
|
(20,000) |
|
|
Net Cash used in Investing Activities |
|
(60,400) |
||
C. |
Cash Flow from Financing Activities |
|
|
||
|
|
Issue of Equity Shares |
|
40,000 |
|
|
|
Dividend paid |
|
(11,200) |
|
|
|
Redemption of 10% Preference Shares |
|
(20,000) |
|
|
Net Cash from Financing Activities |
|
8,800 |
||
D. |
Net Increase in Cash and Cash Equivalent |
|
4,400 |
||
|
|
Add: |
Cash and Cash Equivalent in the beginning |
|
6,800 |
E. |
Cash and Cash Equivalents at the end |
|
11,200 |
Working Notes:
1.
Plant Account
Dr. |
|
|
|
|
|
|
Cr. |
Date |
Particulars |
J.F. |
Amount Rs |
Date |
Particulars |
J.F. |
Amount Rs |
|
To Balance b/d |
|
36,000 |
|
By Depreciation |
|
10,000 |
|
To Bank A/c (Purchases- Balancing figure) |
|
50,400 |
|
By Balance c/d |
|
76,400 |
|
|
|
86,400 |
|
|
|
86,400 |
2.
Net Profit before Tax |
3,600 |
|
Profit and Loss Account |
12,800 |
|
Less: |
Provision for Tax |
16,400 |
Note: As per the solution, the Net Cash from Operating Activities, net Cash from Investing Activities and Net Cash from Financing Activities are Rs 56,000, Rs (60400) and Rs 8,800 respectively. However, as per the answer given in the book, the Net Cash from Operating Activities, net Cash from Investing Activities and Net Cash from Financing Activities are Rs 34,800, Rs (50,400) and Rs 20,000 respectively.
APPEARS IN
RELATED QUESTIONS
Give the meaning of 'Cash Flow statement'.
'Interest received and paid' is considered as which type of activity by a finance company while preparing a Cash Flow Statement?
State whether the following will increase, decrease or have no effect on cash flow from operating activities while preparing 'Cash Flow Statement':
1) A decrease in outstanding employees benefits expenses by Rs 3,000
2) Increase in prepaid insurance by Rs 2,000
Which of the following transactions will result in 'Flow of Cash’?
(a) Deposited Rs 10,000 into the bank.
(b) Withdrew cash from bank Rs 14,500.
(c) Sale of the machinery of the book value of Rs 74,000 at a loss of Rs 9,000.
(d) Converted Rs 2,00,000 9% debentures into equity shares.
The accountant of Manav Ltd. while preparing Cash Flow Statement added depreciation provided on fixed assets to net profit for calculating cash flow from operating activities. Was he correct in doing so? Give reason.
While preparing Cash Flow Statement, the accountant of 'Rachana Ltd.', a financing company, included 'Interest received on loan' in financing activities. Was the correct in doing so? Give reason.
Which of the following transactions will result in the flow of cash?
Answer the following question:
State any one objective of preparing Cash Flow Statement.
List any two investing activities which result into outflow of cash.
Short Answer Question
Prepare a format of cash flow from operating activities under indirect method.
From the following particulars of Bharat Gas Limited, calculate Cash Flows from Investing Activities. Also, show the workings clearly preparing the ledger accounts:
Balance Sheet of Bharat Gas Ltd. as on 31 Mar. 2016 and 31 Mar. 2017
Particulars | Note No. | Figures as the end of 2017 (Rs) |
Figures as at the end of reporting 2016 (Rs) |
II) Assets | |||
1. Non-current Assets |
|||
a) Fixed assets |
|||
i) Tangible assets |
1 | 12,40,000 | 10,20,000 |
ii) Intangible assets |
2 | 4,60,000 | 3,80,000 |
b) Non-current investments |
3 | 3,60,000 | 2,60,000 |
Notes 1 tangible assets = Machinery
2 Intangible assets = Patents
Notes
Figures of current year | Figures of previous year | |
1. Tangible Assets | ||
Machinery |
12,40,000 | 10,20,000 |
2. Intangible Assets | ||
Goodwill |
3,00,000 | 1,00,000 |
Patents |
1,60,000 | 2,80,000 |
4,60,000 | 3,80,000 | |
3. Non-current Investments | ||
10% long term investments |
1,60,000 | 60,000 |
Investment in land |
1,00,000 | 1,00,000 |
Shares of Amartex Ltd. |
1,00,000 | 1,00,000 |
3,60,000 | 2,60,000 | |
Additional Information:
(a) Patents were written-off to the extent of Rs. 40,000 and some Patents were sold at a profit of Rs. 20,000.
(b) A Machine costing Rs. 1,40,000 (Depreciation provided thereon Rs. 60,000) was sold for Rs. 50,000. Depreciation charged during the year was Rs. 1,40,000.
(c) On March 31, 2016, 10% Investments were purchased for Rs. 1,80,000 and some Investments were sold at a profit of Rs. 20,000. Interest on Investment was received on March 31, 2017.
(d) Amartax Ltd. paid Dividend @ 10% on its shares.
(e) A plot of Land had been purchased for investment purposes and let out for commercial use and rent received Rs. 30,000.
What are the benefits of cash flow statements ______?
Which one is Cash Outflows from operating activities?
Classify the following activity into operating activities, investing activities, financing activities or cash activities
"Purchase of machinery"
Classify the following activity into operating activities, investing activities, financing activities or cash activities
"Interest and Dividend received": In case of a financial enterprise (whose main business is lending and borrowing)
From the following information, calculate cash flows from financing activities:
Long-term Loans Rs. 2,09,000 Rs. 2,50,000
During the year, the company repaid a loan of Rs. 1,00,000.
Statement of cash flows includes:
Cash from Operating Activities will decrease due to: