From the following information, prepare a Cash Flow Statement of Pioneer Ltd.
Balance Sheet of Pioneer Ltd. as on March 31, 2017
| Particulars | Note No. | 31st March 2017 (₹) | 31st March 2016 (₹) |
|---|---|---|---|
| I. Equity and Liabilities | |||
| 1. Shareholders' Funds | |||
| a) Share capital | 1 | 7,00,000 | 5,00,000 |
| b) Reserve and surplus | 2 | 4,20,000 | 2,50,000 |
| 2. Non-current Liabilities | |||
| Long-term borrowings: 10% Bank Loan | 50,000 | 1,00,000 | |
| 3. Current Liabilities | |||
| a) Trade Payables | 45,000 | 50,000 | |
| b) Other current liabilities: outstanding rent | 7,000 | 5,000 | |
| c) Short-term provisions | 3 | 50,000 | 30,000 |
| Total | 12,72,000 | 9,35,000 | |
| II. Assets | |||
| 1. Non-current assets | |||
| a) Fixed assets — (i) Tangible assets | 4 | 5,00,000 | 5,00,000 |
| (ii) Intangible assets | 5 | 95,000 | 1,00,000 |
| b) Non-current investments | 1,00,000 | — | |
| 2. Current assets | |||
| a) Inventories | 1,30,000 | 50,000 | |
| b) Trade receivables | 1,20,000 | 80,000 | |
| c) Cash and cash equivalents | 6 | 3,27,000 | 2,05,000 |
| Total | 12,72,000 | 9,35,000 |
Notes to Accounts:
Note 1 — Share Capital
| Particulars | 31st March 2017 (₹) | 31st March 2016 (₹) |
|---|---|---|
| Equity Share Capital | 7,00,000 | 5,00,000 |
Note 2 — Reserve and Surplus
| Particulars | 31st March 2017 (₹) | 31st March 2016 (₹) |
|---|---|---|
| Surplus (Balance in Statement of Profit and Loss) | 4,20,000 | 2,50,000 |
Note 3 — Short-term Provisions
| Particulars | 31st March 2017 (₹) | 31st March 2016 (₹) |
|---|---|---|
| Provision for Taxation | 50,000 | 30,000 |
Note 4 — Tangible Assets
| Particulars | 31st March 2017 (₹) | 31st March 2016 (₹) |
|---|---|---|
| Equipments | 2,30,000 | 2,00,000 |
| Furniture | 2,70,000 | 3,00,000 |
Note 5 — Intangible Assets
| Particulars | 31st March 2017 (₹) | 31st March 2016 (₹) |
|---|---|---|
| Patents | 95,000 | 1,00,000 |
Note 6 — Cash and Cash Equivalents
| Particulars | 31st March 2017 (₹) | 31st March 2016 (₹) |
|---|---|---|
| Cash | 27,000 | 5,000 |
| Bank Balance | 3,00,000 | 2,00,000 |
Additional Information: During the year, equipment costing ₹80,000 was purchased; loss on sale of equipment amounted to ₹5,000; depreciation of ₹15,000 and ₹3,000 was charged on equipments and furniture respectively; a loan of ₹50,000 was repaid on 31.03.2017; and the proposed dividend for the year 2015-16 was ₹50,000.
Operating activities generate ₹1,82,000, investing uses ₹1,50,000, and financing provides ₹90,000 — a net increase of ₹1,22,000, reconciling opening cash ₹2,05,000 to closing ₹3,27,000.
Cash Flow Statement of Pioneer Ltd.
| Particulars | Amount (₹) |
|---|---|
| I. Cash flows from Operating Activities | |
| Net Profit before taxation & extraordinary items | 2,70,000 |
| Add: Depreciation on equipment | 15,000 |
| Add: Depreciation on furniture | 30,000 |
| Add: Patents written-off | 5,000 |
| Add: Loss on sale of equipments | 5,000 |
| Add: Interest on bank loan | 10,000 |
| Operating Profit before Working Capital changes | 3,35,000 |
| Less: Decrease in trade payables | (5,000) |
| Add: Increase in outstanding rent | 2,000 |
| Less: Increase in trade receivables | (40,000) |
| Less: Increase in inventories | (80,000) |
| Cash generated from operating activities | 2,12,000 |
| Less: Tax paid | (30,000) |
| A. Net Cash Inflows from Operating Activities | 1,82,000 |
| II. Cash flows from Investing Activities | |
| Proceeds from sale of equipments | 30,000 |
| Purchase of new equipment | (80,000) |
| Purchase of investments | (1,00,000) |
| B. Net Cash used in Investing Activities | (1,50,000) |
| III. Cash flows from Financing Activities | |
| Issue of equity share capital | 2,00,000 |
| Repayment of bank loan | (50,000) |
| Payment of dividend | (50,000) |
| Payment of interest on bank loan | (10,000) |
| C. Net Cash Inflows from Financing Activities | 90,000 |
| Net increase in Cash & Cash Equivalents (A + B + C) | 1,22,000 |
| Add: Cash and Cash Equivalents in the beginning | 2,05,000 |
| Cash and Cash Equivalents in the end | 3,27,000 |
Working Note 1 — Equipment Account
| Particulars | Amount (₹) | Particulars | Amount (₹) |
|---|---|---|---|
| To Balance b/d | 2,00,000 | By Depreciation | 15,000 |
| To Cash (purchase) | 80,000 | By Bank (sale) | 30,000 |
| By Statement of Profit & Loss (loss on sale) | 5,000 | ||
| By Balance c/d | 2,30,000 | ||
| Total | 2,80,000 | Total | 2,80,000 |
Working Note 2 — Calculation of Net Profit before Taxation
| Particulars | Amount (₹) |
|---|---|
| Surplus (Statement of Profit & Loss) at the end | 4,20,000 |
| Less: Surplus at the beginning | (2,50,000) |
| Net Profit during the year | 1,70,000 |
| Add: Provision for tax during the year | 50,000 |
| Add: Proposed dividend (2015-16) | 50,000 |
| Net Profit before taxation & extraordinary items | 2,70,000 |
Patents of ₹5,000 (₹1,00,000 − ₹95,000) were written off; depreciation on furniture was ₹30,000 (₹3,00,000 − ₹2,70,000). The proposed dividend of ₹50,000 and tax of ₹30,000 provided in 2015-16 are assumed paid during 2016-17.
Net cash from Operating ₹1,82,000; used in Investing (₹1,50,000); from Financing ₹90,000; net increase ₹1,22,000, taking Cash and Cash Equivalents from ₹2,05,000 to ₹3,27,000.
Unlock everything free for 14 days
- Full step-by-step solutions
- Concept-first explanations
- Methods, shortcuts & mistakes
- PYQ mapping + timed mock tests
Full access for 14 days. No credit card required.