Advertisements
Advertisements
Question
Prepare a Cash Flow Statement from the following Balance Sheets of Arya Ltd.:
Particulars | Note | 31.3.2023 (₹) | 31.3.2022 (₹) | |
I. | Equity and Liabilities: | |||
(1) | Shareholders’ Funds: | |||
a) | Share Capital | 1 | 10,00,000 | 8,00,000 |
b) | Reserves and Surplus | 2 | 6,40,000 | 5,40,000 |
(2) | Non-Current Liabilities: | |||
Long-term Borrowings | 1,50,000 | 1,00,000 | ||
(3) | Current Liabilities: | |||
a) | Trade Payables | 3 | 30,000 | 12,000 |
b) | Short-term Provisions | 30,000 | 28,000 | |
Total | 18,50,000 | 14,80,000 | ||
II. | Assets: | |||
(1) | Non-Current Assets: | |||
a) | Property, Plant and equipment and intangible assets: Property, Plant and Equipment |
4 | 7,75,000 | 4,90,000 |
b) | Non-current Investments | 90,000 | 50,000 | |
(2) | Current Assets | |||
a) | Inventory | 6,20,000 | 4,13,000 | |
b) | Trade receivables | 3,20,000 | 4,94,000 | |
c) | Cash & Cash Equivalents | 45,000 | 33,000 | |
Total | 18,50,000 | 14,80,000 |
Notes to Accounts:
Particulars | 31.3.2023 | 31.3.2022 | |
1. | Reserves & Surplus: | ||
General Reserve | 5,00,000 | 4,30,000 | |
Capital Reserve | 60,000 | 50,000 | |
Surplus ie balance in statement of profit and loss | 80,000 | 60,000 | |
6,40,000 | 5,40,000 | ||
2. | Long-term Borrowings: | ||
10% Debentures | 1,50,000 | 1,00,000 | |
3. | Short-term Provisions: | ||
Provision for tax | 30,000 | 28,000 | |
4. | Tangible Assets: | ||
Plant and Machinery | 7,75,000 | 4,90,000 |
Additional Information:
- Tax provided during the year is ₹ 17,000.
- Depreciation charged on plant and Machinery during the year amounted to ₹ 1,20,000.
- Non-current Investments costing ₹ 30,000 were sold for ₹ 40,000 during the year. Gain on sale of Investments was credited to Capital Reserve.
- Additional Debentures were issued on 31.03.2023.
Solution
Cash Flow Statement for the year ended March 31, 2023 | ||
Particulars | Details | Amount (₹) |
Cash from Operating Activities | ||
Profits before Tax and Extraordinary Activities | 1,07,000 | |
Add:- Non-Cash and Non-Operating Expenses | ||
Depreciation on Plant and Machinery | 1,20,000 | |
Interest on Debentures | 10,000 | |
Cash from Operating Activities before working capital changes | 2,37,000 | |
Increase in Trade Payables | 18,000 | |
Decrease in Trade Receivable | 1,74,000 | |
Increase in Inventory | (2,07,000) | |
Cash from Operations | 2,22,000 | |
Less:- Tax Paid | (15,000) | |
Cash from Operating Activities (A) | 2,07,000 | |
Cash from Investing Activities | ||
Sale of Investments | 40,000 | |
Purchase of Investments | (70,000) | |
Purchase of Plant and Machinery | (4,05,000) | |
Cash from Investing Activities (B) | (4,35,000) | |
Cash from Financing Activities | ||
Issue of Shares | 2,00,000 | |
Issue of Debentures | 50,000 | |
Interest on Debentures | (10,000) | |
Cash from Financing Activities (C) | 2,40,000 | |
Net Cash Flow during the year (A+B+C) | 12,000 | |
Add:- Opening Cash and Cash Equivalents | 33,000 | |
Closing Cash and Cash Equivalents | 45,000 |
Working Notes:-
Plant and Machinery Account | |||
Particulars | Amount (₹) | Particulars | Amount (₹) |
Balance b/d | 4,90,000 | Depreciation A/c | 1,20,000 |
Bank (Purchase) | 4,05,000 | Balance c/d | 7,75,000 |
8,95,000 | 8,95,000 |
Investments Account | |||
Particulars | Amount (₹) | Particulars | Amount (₹) |
Balance b/d | 50,000 | Bank A/c (sale) | 40,000 |
Gain on Sale (Capital Reserve) |
10,000 | Balance c/d | 90,000 |
Bank (Purchase) | 70,000 | ||
1,30,000 | 1,30,000 |
Provision for Tax Account | |||
Particulars | Amount (₹) | Particulars | Amount (₹) |
Bank (Paid) | 15,000 | Balance b/d | 28,000 |
Balance c/d | 30,000 | Statement of Profit and Loss |
17,000 |
45,000 | 45,000 |
Net Profits after Tax and Extraordinary Items = 20,000
+ Transfer to General Reserve = 70,000
+ Provision for Tax = 17,000
= Net Profits before Tax and Extraordinary Items = 1,07,000
APPEARS IN
RELATED QUESTIONS
Short Answer Question
How are the various activities classified (as per AS-3 revised) while preparing cash flow statement?
Classify the following transactions as Operating Activities for a financial company and a non-financial company:
(a) Purchase of Shares on a Stock Exchange.
(b) Dividend received on Shares.
(c) Dividend paid on Shares.
(d) Loans given.
(e) Loans taken.
(f) Interest paid on borrowings.
Answer the following question:
From the following information, calculate the amount of cash flow from investing activities.
Acquired machinery for 10,00,000, paying 10% immediately in cash and accepting a draft for the balance in favour of the vendor, payable after three months.
What is meant by 'Operating Activities'?
Insurance Claim received by Albert Co. Ltd. of ₹ 5,00,000 for Loss of Machinery due to theft will be recorded in Cash Flow Statement in which of the following manner?
A company issued 20,000; 9% Debentures of ₹ 100 each at 10% Discount. These debentures were to be redeemed at 15% Premium at the end of 5 years. The balance in Securities Premium Account as of the date of Issue was ₹ 3,70,000. How this transaction will be reflected in Cash Flow Statement?
Read the following hypothetical text and answer the given questions on the basis of the same:
Aashna, an alumnus of CBSE School, initiated her start up Smartpay, in 2015. Smartpay is a service platform that processes payments via UPI and POS, and provides credit or loans to their clients. During the year 2021-22, Smartpay issued bonus shares in the ratio of 5:1 by capitalising reserves. The profits of Smartpay in the year 2021-22 after all appropriations was ₹ 7,50,000. This profit was arrived after taking into consideration the following items -
Particulars | Amount (₹) |
Interim Dividend paid during the year | 90,000 |
Depreciation on Machinery | 40,000 |
Loss of Machinery due to fire | 20,000 |
Insurance claim received for Loss of Machinery due to Fire |
10,000 |
Interest on Non-Current Investments received | 30,000 |
Tax Refund | 20,000 |
Additional Information:
Particulars | 31.3.22 (₹) | 31.3.21 (₹) |
Equity Share Capital | 12,00,000 | 10,00,000 |
Securities Premium Account | 3,00,000 | 5,00,000 |
General Reserve | 1,50,000 | 1,50,000 |
Investment in Marketable Securities | 1,50,000 | 1,00,000 |
Cash in hand | 2,00,000 | 3,00,000 |
Machinery | 3,00,000 | 2,00,000 |
10% Non-Current Investments | 4,00,000 | 3,00,000 |
Bank Overdraft | 2,50,000 | 2,00,000 |
Goodwill | 30,000 | 80,000 |
Provision for Tax | 80,000 | 60,000 |
- Goodwill purchased during the year was ₹ 20,000.
- Proposed Dividend for the year ended March 31, 2021 was ₹ 1,60,000 and for the year ended March 31, 2022 was ₹ 2,00,000.
You are required to:
- Calculate Net Profit before tax and extraordinary items.
- Calculate Operating profit before working capital changes.
- Calculate Cash flow from Investing activities.
- Calculate Cash flow from Financing activities.
- Calculate closing cash and cash equivalents.
Calculate 'Cash Flows from Investing Activities' and 'Cash Flows from Financing Activities' for the year ended 31st March 2021 from the following Balance Sheet of Kamna Ltd. as 31st March 2021 showing your workings clearly:
Kamna Ltd. Balance Sheet as at 31st March, 2021 |
|||
Particulars | Note No. | 31st March, 2021 (₹) |
31st March, 2020 (₹) |
I. Equity and Liabilities | |||
1. Shareholders' Funds | |||
(a) Share Capital | 12,00,000 | 11,00,000 | |
(b) Reserves and surplus | 1 | 3,00,000 | 2,00,000 |
2. Non-Current Liabilities | |||
Long-term borrowings | 2,40,000 | 1,70,000 | |
3. Current Liabilities | |||
Trade payables | 2,20,000 | 2,81,000 | |
Total | 19,60,000 | 17,51,000 | |
II. Assets | |||
1. Non Current Assets | |||
(a) Fixed Assets | |||
(i) Tangible Assets | 2 | 10,70,000 | 8,50,000 |
(ii) Intangible Assets | 3 | 40,000 | 1,12,000 |
2. Current Assets | |||
(a) Current Investments | 2,40,000 | 1,50,000 | |
(b) Inventories | 1,20,000 | 1,21,000 | |
(c) Trade Receivables | 1,70,000 | 1,43,000 | |
(d) Cash and Cash Equivalents | 3,20,000 | 3,75,000 | |
Total | 19,60,000 | 17,51,000 |
Notes to Accounts:
Note No. |
Particulars | 31st March, 2021 (₹) |
31st March, 2020 (₹) |
1. | Reserve and Surplus: | 3,00,000 | 2,00,000 |
Surplus i.e. Balance in | |||
Statement of Profit & Loss | |||
2. | Tangible Assets: | ||
Machinery | 12,70,000 | 10,00,000 | |
Accumulated Depreciation | (2,00,000) | (1,50,000) | |
10,70,000 | 8,50,000 | ||
3. | Intangible Assets: | ||
Goodwill | 4,000 | 1,12,000 |
Additional Information:
A piece of machinery costing ₹ 24,000 on which accumulated depreciation was ₹ 16,000, was sold for ₹ 6,000.
In case of a financial enterprise whose main business is lending and borrowing, ‘interest paid' and ‘interest received’ are classified as ______.
Which of the following transaction will result in no flow of cash?
Match the transactions given in column - II with their correct category given in Column - I for the purpose of preparation of 'Cash Flow Statement'.
Column - I | Column - II | ||
(a) | Investing Activity | (i) | Interest paid |
(b) | Financing Activity | (ii) | Purchase of Goodwill |
(c) | Operating Activity | (iii) | Cash receipts from sale of goods |
What will be the effect of issue of Bonus shares on Cash Flow Statement?