After studying this chapter you should be able to understand:
The meaning of cash flow and cash flow statement
The uses of cash flow statement
The limitations of cash flow statement
The classification of business transactions into operating activities, investing activities and financing activities according to Accounting Standard-3 (Revised)
Preparation of cash slow statement as per (AS)-3 by both direct and indirect methods
Accounting treatment of special items (non-cash expense non-operating income)
Various stages involved in the preparation of cash flow statement (six stages with illustrations) in accordance with accounting standard (AS)-3 (Revised)
The end product of the accounting process is the ‘financial statements’. These are nothing but the summarized statements of accounting data produced at the end of the accounting process by a business entity. These statements communicate accounting information to the users. The balance sheet and the profit and loss account (income statement) are the traditional financial statements of any business entity. A balance sheet shows the financial position of a business enterprise on the last day of an accounting period. It is only a statement of assets and liabilities stating the financial position of an enterprise at a given date. A profit and loss account (income statement) shows the financial performance (i.e. profit or loss) of a business entity during the specified period (i.e. accounting period). However, revenue recorded in profit and loss account will not reflect cash inflows. Likewise, some of the expenses shown in profit and loss account will be non-cash expenses (like depreciation and amortization) and some will not be paid in full (goods purchased on credit outstanding expenses). As such the periods profit or loss will not be bear any direct relationship with cash flows relating to that specified accounting period. No exact information will be obtained from these two traditional financial statements with regard to investing or financing activities of business entities. Hence, the need arises to access the inflows and outflows of cash during the accounting period. Keeping in view this aspect, the Institute of Chartered Accountants of India (ICAI) introduced one more essential component of financial statements known as cash flow statement. As per accounting standard-3 (Revised), the preparation of cash flow statement—as the thirdfinancial statement–has become statutory for any companies registered under the Companies Act 1956. The other forms of business organizations also prepare this third financial statement, namely cash flow statement. This cash flow statement has to be prepared to provide information about the cash flows associated with operating, investing and financing activities of business entities during an accounting period. In a nutshell, the cash flow statement reflects ‘sources and uses of cash’. This statement reveals ‘where cash comes from and where it goes’. This chapter describes the financial statement in detail.
Cash flow and cash flow statement are described as follows:
Cash: This term includes cash on hand and also demands deposits with banks. The demand deposit is a deposit, which can be repayable in cash by bank on demand by the person who made such a deposit.
Cash equivalents: This term represents the highly liquid investments, which are convertible into cash with ease and speed. They are relatively short-term investments. No risk arises in converting them into cash. Their maturity period is below 3 months; preferably investments in shares are not treated as cash equivalents. The prime object of cash equivalent is to meet short-term cash commitments. Hence, they are not meant for investments or other purposes.
Cash flows: This term refers to inflows and outflows of cash and cash equivalents. An outflow will increase the cash and cash equivalents. The difference between the cash inflows and cash outflows is termed as ‘net cash flow’. The net cash flow may be either a net cash inflow or a net cash outflow. It is pertinent to note that cash flows exclude movements between the items, which constitute cash or cash equivalents.
Cash flow statements: Cash flow statement is nothing but a statement that reflects inflows and outflows of cash and cash equivalents. Simply put, inflow means receipts and outflow means payment of a business entity.
The revised accounting standard [AS-3 (Revised)] is issued by the ICAI in March 1997.
Accordingly, cash flow statement has replaced statement of changes in financial position. The accounting standard [As-3 (Revised)] has been made mandatory with effect from accounting period on or after 1 April 2001 for enterprises, which fall in anyone or more of the specified categories.
Following are the uses of cash flow statement:
Limitations of cash flow statements are as follows:
Cash flow statements may be prepared by two methods: (a) direct method and (b) indirect method.
Following are example of cash inflows (cash receipts):
Following are example of cash outflows (cash payments):
The difference between total cash receipts and total payments is found out, which is called ‘the net cash’ provided by (or used in) operating activities.
These two methods are explained through illustrations in the forthcoming pages.
The other two activities, i.e. cash flows from investing activities and financing activities also are illustrated.
Finally, in illustration No. 37, both the methods are explained, from which the students can understand with ease and better comprehension.
As per the syllabus, cash flow statements are to be prepared as per revised standard issued by ICAI.
This revised standard is better known among professional accountants, as ‘accounting standard-3 (Revised)’.
This AS-3 requires a cash flow statement to be prepared and presented in a manner that it shows cash flow from business transactions during a period, which is classified as follows:
This classification of business transactions as per AS-3 may be represented as follows for easy comprehension:
Cash Inflow | Cash Outflow |
---|---|
1. Cash Sales: Cash Receipts from Sale of Goods & Other Related Services |
1. Cash Purchases |
2. Cash Receipts from Debtors |
2. Cash Payment to Suppliers of Goods and Services |
3. Cash Receipts from Royalties, Fees, Commission and Others |
3. Cash Payment to Suppliers of Goods and Services |
4. Cash Receipts from Insurance Company on Policy Benefits |
4. Cash Payment of Wages |
|
5. Cash Payment to Insurance Companies as Premium and so on |
|
6. Cash Payment to Income Tax |
(a) Cash Received on Interest and Dividends |
(a) Interest Payment |
(b) Sale of Securities |
(b) Securities Purchased |
Cash Inflow | Cash Outflow |
---|---|
1. Cash Proceeds (Receipts) from Issue of Shares (in Cash) |
1. Payment of Loans |
2. Cash Proceeds from Issue of Debentures |
2. Redemption of Preference Shares |
3. Cash Proceeds from Long-term Borrowings |
3. Payment of Dividend |
|
4. Payment of Interest |
|
5. Repayment of Any Finance Liability |
Note:
This is not a distinction or difference between cash inflow and outflow, but only a representation of various cash inflows and outflows for each type of activities. This only facilitates easy comprehension and better remembrance of cash inflow and outflow for each of the activities classified.
Illustration 16.1
From the following activities, classify (1) operating activities, (2) investing activities and (3) financing activities.
Requirements:
Solution
Financing activities: Issue of debenture, buy-back of shares and repayment of long-term loan (manufacturer concern)
Operating activities: Sale of investment, income tax paid and office expenses
Investing activities: Sale of machinery, sale of investment (financial concerns) and sale of patent
Cash equivalents: Bank balance and investment in marketable securities (short term)
AS-3 requires that the cash flow statement should show separately the activities, i.e.:
Before the preparation of cash flow statements, one should be familiar with the proforma or format of cash flow statement under two different methods: (i) direct method and (ii) indirect method.
These are the revised formats as issued by ICAI (Revised) as per (AS)-3 (Revised)
Particulars | ||
---|---|---|
1. Cash From Operating Activities |
|
|
A: Operating Cash Receipts |
|
|
(i) Cash Sales |
… |
|
(ii) Cash Received from Customers |
… |
|
(iii) Trading Commission Received |
… |
|
(iv) Royalties Received |
… |
|
(v) Others |
… |
xxx (A) |
B: Operating Cash Payment |
|
|
(i) Cash Purchases |
(…) |
|
(ii) Cash Paid to Suppliers |
(…) |
|
(iii) Cash Paid to Business Expenses (Office Expenses, Manufacturing Expense, Selling Expense) |
(…) |
|
(iv) Others |
(…) |
xxx (B) |
C: Cash Generated from Operation (A – B) |
|
xxx (A – B) |
D: Income Tax Paid |
|
|
E: Cash Flow Before Extra Ordinary Items |
|
xx |
F: Extraordinary Items (Receipts/Payments) |
+ |
xxx |
G: Net Cash from Operating Activities |
or (−) |
(…) |
|
|
xxxx |
2. Cash Flow from Investing Activities (As in Indirect Method) |
|
xxx |
3. Cash Flow from Financing Activities (As in Indirect Method) |
|
xx |
4. Net Increase/Decrease in Cash and Cash Equivalents |
|
xx |
(As in Indirect Method) (1 + 2 + 3) |
|
|
5. Add Cash and Cash Equivalents At the Beginning of the Year (Same as in Indirect Method) |
|
xx |
6. Cash and Cash Equivalent at the End of the Year |
|
xx |
Particulars | ||
---|---|---|
1. Cash From Operating Activities |
|
|
A: Net Profit Before Taxation and Extraordinary Items |
|
xxx |
B: Add: Items to Be Added: |
|
|
(i) Depreciation |
… |
|
(ii) Preliminary Expenses Written off |
… |
|
(iii) Discount on Issue of Shares and Debentures Written off |
… |
|
(iv) Goodwill Written off |
… |
|
(vi) Interest on Borrowings and Debentures |
… |
|
(vi) Interest on Borrowings and Debentures (Only for Non-finance Companies to be Shown—Under Financial Activities) |
… |
|
Loss on Sale of Fixed Assets |
… |
xxx |
C: Less: Items to Be Deducted: |
|
|
(i) Interest Income (Only for Non-finance Companies—to be Shown Under Investment Activities) |
… |
|
(ii) Dividend Income (for Non-finance Companies—to be Shown Under Investment Activities |
… |
|
(iii) Rental Income |
… |
|
(iv) Profit on Sale of Fixed Assets |
… |
xxx |
(To Be Shown Under Investment Activities—Sale Price) |
|
|
D: Operating Profit Before Working Capital Charges (A + B − C) |
… |
|
E: Add: Decrease in Current Assets and Increase in Current Liabilities Detail: |
|
|
(i) Decrease in Stock/Inventories |
… |
|
(ii) Decrease in Debtors/B/R |
… |
|
(iii) Decrease in Accrued Incomes |
… |
|
(iv) Decrease in Prepaid Expenses |
… |
|
(v) Increase in Creditors/B/P |
… |
|
(vi) Increase in Outstanding Expenses |
… |
|
(vii) Increase in Advanced Income |
… |
|
(viii) Increase in Provision for Doubtful Debt |
… |
xxx |
F: Less: Increase in Current Assets and Decrease in Current Liabilities |
|
|
(i) Increase in Stock/Inventories |
… |
|
(ii) Increase in Debtors/B/R |
… |
|
(iii) Increase in Accrued Incomes |
… |
|
(iv) Increase in Prepaid Expenses |
… |
|
(v) Decrease in Creditors/B/P |
… |
|
(vi) Decrease in Outstanding Expenses |
… |
|
(vii) Decrease in Advanced Income |
… |
|
(viii) Decrease in Provision for Doubtful Debt |
… |
xxx |
G: Cash Generated from Operations (D + E − F) |
… |
xxx |
H: Less Income Tax Paid |
|
(…) |
I: Cash Flow Before Extraordinary Items, Extraordinary Items (±) |
|
xxx |
J: Net Cash from (or Used in) Operating Activities |
|
xxx |
2. Cash Flow from Investing Activities |
… |
|
(i) Proceeds from Sale of Fixed Assets |
… |
|
(ii) Proceeds from Sale of Investments |
… |
|
(iii) Interest and Dividend Received (for Non-finance Companies Only) |
… |
|
(iv) Rent Income |
|
|
(v) Purchase of Fixed Assets |
(…) |
|
(vi) Purchase of Investments |
(…) |
|
(vii) Purchase of Intangible Assets, e.g. Goodwill |
(…) |
|
(viii) Extraordinary Items (± or) |
(…) |
|
Net Cash from (Used in Investing Activities) |
|
xxx |
3. Cash Flow from Financing Activities |
|
|
(i) Proceeds from Issue of Shares and Debentures |
… |
|
(ii) Proceeds from Other Long-term Borrowings |
… |
|
(iii) Financial Dividend Paid |
… |
|
(iv) Interim Dividend Paid |
(…) |
|
(v) Interest on Loans and Debentures |
(…) |
|
(vi) Repayment of Loans |
(…) |
|
(vii) Redemption of Debentures/Prët |
(…) |
|
(viii) Extraordinary Items ( + or−) |
(…) |
|
Net Cash from (or Used in) Financing Activities |
|
xxx |
4. Net Increase/Decrease in Cash and Cash Equivalents (1 + 2 + 3) |
|
xxx |
5. Cash and Cash Equivalents at the Beginning of the Year |
|
|
(i) Cash in Hand |
… |
|
(ii) Cash at Bank (Less: O/D) |
… |
|
(iii) Short-term Deposits |
… |
|
(iv) Marketable Securities |
… |
xx |
|
|
xxx |
6. Cash and Cash Equivalents at the End of the Year |
|
|
(i) Cash in Hand |
… |
|
(ii) Cash at Bank (Less: O/D) |
… |
|
(iii) Short-term Deposits |
… |
|
(iv) Marketable Securities |
… |
xxx |
Illustration 16.2
You are required to calculate cash inflow from debtors from the following data.
Particulars |
|
Total Sales |
5,00,000 |
Cash Sales |
2,00,000 |
Opening Debtors |
50,000 |
Closing Debtors |
80,000 |
Sales Returns |
20,000 |
Solution
Cash inflow from debtors has to be computed. This can be prepared by two methods.
Method 1: Cash inflow from debtors: first the format has to be drawn. Then transfer the items as follows:
Particulars | ||
---|---|---|
Opening Balance |
|
50,000 |
Add: Credit Sales: Total Sales |
5,00,000 |
|
Less: Cash Sales |
2,00,000 |
3,00,000 |
Less: Sales Returns |
(20,000) |
3,50,000 |
Closing Balance of Debtors |
(80,000) |
(1,00,000) |
Cash Inflow from Debtors |
|
2,50,000 |
Note:
Step (a): |
Opening Debtors Has to be Taken as Base (Given in the Question). |
Step (b): |
With this Credit Sales (Total Sale – Cash Sale) is Added. |
|
|
Step (c): |
Then, Sales Returns and Closing Balance of Debtors to be Deducted. |
Step (d): |
The Result Shows Cash Inflow from Debtors. |
Total debtors account (ledger) is computed as above.
Note:
*1. Cash inflow from debtors is the balancing figure ( 2,50,000).
2. Any one method may be adopted. The result will be the same under both the methods, i.e. cash inflow from debtors: 2,50,000.
Illustration 16.3
From the following calculate cash inflow from debtors.
Particulars |
|
Opening Debtors |
20,000 |
Closing Debtors |
40,000 |
Opening Bills Receivables |
15,000 |
Closing Bills Receivables |
25,000 |
Total Sales |
3,00,000 |
Cash Sales |
20% of Credit Sales |
Discount Allowed |
10,000 |
Bad Debts |
15,000 |
Discount Allowed |
20,000 |
Sales Returns |
35,000 |
Solution
First value of credit sales is to be calculated (irrespective of the method to the adopted)
Let Credit sales be taken as = x
Hence x: credit sales = 2,50,000
Particulars | ||
---|---|---|
Opening Debtors |
|
20,000 |
Opening Bills Receivable |
|
15,000 |
Add: Credit Sales (Worked Out Above) |
|
2,50,000 |
|
|
2,85,000 |
Less: Discount Allowed |
(10,000) |
|
Bad Debts |
(15,000) |
|
Sales Returns |
(35,000) |
|
Closing Debtors |
(40,000) |
|
Closing Bills Receivables |
(25,000) |
(1,25,000) |
|
|
1,60,000 |
Illustration 16.4
Calculate the amount of trading commission received during the year 2010 from the following data.
|
January 2010 |
31 December 2010 |
|
||
Accrued Trading Commission |
10,000 |
15,000 |
Advance Trading Commission |
45,000 |
60,000 |
Trading commission earned during the year 2010 is 1,70,000.
Solution
Trading commission received can also be computed in two different ways: (i) statement form and (ii) account form.
Particulars | ||
---|---|---|
Trading Commission Earning During 2010 |
|
1,70,000 |
Add: |
|
|
1. Accrued Trading Commission as on 1 January 2010 |
10,000 |
|
2. Advance Trading Commission as on 31 December 2010 |
60,000 |
70,000 |
Less: |
|
2,40,000 |
1. Accrued Trading Commission as on 31 December 2010 |
15,000 |
|
2. Advance Trading Commission as on 1 January 2010 |
45,000 |
60,000 |
|
|
1,80,000 |
Credit Purchases:
This can also be calculated by preparing total creditors account (the balancing figure and bills payable can be inserted in the A/c by preparing bills payable A/c (balancing figure)
Illustration 16.5
Calculate cash outflow to creditors from the following.
Total Purchases |
: |
1,80,000 |
Cash Purchases |
: |
50% of Credit Purchases |
Opening Creditors |
: |
5000 |
Closing Creditors |
: |
20,000 |
Purchase Returns |
: |
25,000 |
Discount (Received) |
: |
10,000 |
Solution
First, we have to calculate credit purchase. Credit purchase is not given in the problem. So, let us assume, credit purchases = x.
Cash purchase is given as 50% of credit purchase
So, cash purchase = x/2
Total Purchases = Cash Purchase + Credit Purchase
Particulars | ||
---|---|---|
Opening Balance of Creditors |
|
5,000 |
Add: Credit Purchases |
|
1,20,000 |
Less: |
|
1,25,000 |
(i) Closing Balance of Creditors |
(20,000) |
|
(ii) Discount Received |
(1 0,000) |
|
(iii) Purchase Returns |
(25,000) |
(55,000) |
Cash Outflow to Creditors |
|
70,000 |
*1Note: Balancing figure = 1,25,000 – 55,000 = 70,000.
Illustration 16.6
Complete cash outflow to creditors from the following.
|
|
|
Cost of Goods Sold |
: |
3,00,000 |
Operating Stock |
: |
5,000 |
Closing Stock |
: |
15,000 |
Opening Balance of Creditors |
: |
25,000 |
Return Outwards |
: |
10,000 |
Discount Received |
: |
15,000 |
Opening Bills Payable A/c |
: |
40,000 |
Closing Bills Payable A/c |
: |
50,000 |
Closing Balance of Creditors |
: |
40,000 |
Cash Purchases |
: |
60,000 |
Solution
Credit purchase will have to be calculated first.
For this, total purchase is calculated from the figures.
(Students should note that cost of sales and cost of goods sold are one and the same).
= 3,00,000 + 15,000 – 5,000 = 3,10,000
Then, Credit Purchases = Total Purchases – Cash Purchases
Particulars | ||
---|---|---|
Opening Balance of Creditors A/c |
|
25,000 |
Opening Balance of Bills Payable A/c |
|
40,000 |
Add: Credit Purchases |
|
2,50,000 |
|
|
3,15,000 |
Less: |
|
|
1. Discount Received |
(15,000) |
|
2. Return Outwards |
(10,000) |
|
3. Closing Balance |
(40,000) |
|
4. Closing Balance of Bills Payable |
(50,000) |
(1,15,000) |
Cash Outflow to Creditors |
|
2,00,000 |
To find out cash outflow, the amount of expenses (given in P & L A/c) has to be adjusted.
Step 1: |
For this * (i) Amount outstanding at the beginning and (ii) prepaid at the end have to be added (given in P & L A/c) |
Step 2: |
(i) Amount outstanding at the end and (ii) prepaid at the beginning have to be deducted from P & L A/c. |
Step 3: |
Net figure arrived will be the cash paid for expenses. |
Note 1: All non-cash expenses have to be ignored because no cash payment is involved, i.e. cash flow does not take place.
Such expenses are:
Note 2: All appropriations (to be ignored): Outflow of cash does not occur
Note 3: All items related to investing activities and financing activities are ignored because they are taken into calculation of cash flow from investing or financing activities. Examples: Profit/loss on sale of fixed assets.
Illustration 16.7
Compare cash outflow on business expenses from the following (taken from P & L A/c).
|
|
|
Expenses Occurred During the Year 2010 |
: |
25,000 |
Opening Outstanding Expenses |
: |
3,000 |
Closing Outstanding Expenses |
: |
5,000 |
Opening Prepaid Expenses |
: |
4,000 |
Closing Prepaid Expenses |
: |
2,500 |
Solution
Particulars | ||
---|---|---|
Expenses Incurred During the Year |
|
25,000 |
Add: Opening Outstanding Expenses |
3,000 |
|
Closing Prepaid Expenses |
2,500 |
5,500 |
|
|
30,500 |
Less: Closing Outstanding Expenses |
(5,000) |
|
Opening Prepaid Expenses |
(4,000) |
(9,000) |
Cash Outflow Expenses |
|
21,500 |
Illustration 16.8
Calculate cash flow from the following data by direct method.
|
|
|
Cash Sales |
: |
6,00,000 |
Cash Purchases |
: |
3,00,000 |
Royalties Received |
: |
25,000 |
: |
15,000 |
|
Rent Paid |
: |
12,000 |
Tax Paid |
: |
33,000 |
Tax Refund Received |
: |
13,000 |
Received from Debtors |
: |
15,000 |
Paid to Creditors |
: |
5,000 |
and Salaries Paid |
: |
30,000 |
Expenses Paid |
: |
10,000 |
Expenses Paid |
: |
8,000 |
Claim for Tsunami Loss |
: |
35,000 |
Solution
Particulars | ||
---|---|---|
A: Operating Cash Receipts |
|
|
Cash Sales |
|
6,00,000 |
Cash Received from Debtors |
|
15,000 |
Royalties Received |
|
25,000 |
|
|
6,40,000 |
B: Operating Cash Payments |
|
|
Cash Paid to Creditors |
5,000 |
|
Cash Purchases |
3,00,000 |
|
Commission Paid |
15,000 |
|
Rent Paid |
1 2,000 |
|
Wages and Salaries |
30,000 |
|
Manufacturing Expenses |
10,000 |
|
Office Expenses |
8,000 |
(3,80,000) |
|
|
2,60,000 |
C: Cash from Operations Before Tax |
|
|
D: Income Tax Paid |
33,000 |
|
Less: Refund Received |
13,000 |
20,000 |
E: Cash Flow from Operations Before Extraordinary Items |
|
2,40,000 |
F: Extraordinary Items: Insurance Claim for Tsunami |
|
35,000 |
G: Net Cash Flow from Operating Activities |
|
2,05,000 |
So far, we have discussed the calculation of cash flow (operating activities) by direct method, stage by stage. Now we have to discuss this by indirect method.
One has to make adjustments on net profit arrived as in P & L A/c.
To put in a nut shell, the net operating profit before working capital changes has to be adjusted as:
Items to be added: Items, which lead to increase in cash have to be added. They are as follows:
Items to be deducted: Items, which lead to decrease in cash have to be deducted. They are the following:
Illustration 16.9
Calculate cash flow from operating activities: from the following P & L A/c by indirect method.
Solution
First, net profit before tax has to be calculated:
Now, we have to compute cash flow.
Particulars | ||
---|---|---|
Net Profit Before Tax |
|
27,000 |
Adjustments |
|
|
Add: Depreciation |
3,000 |
|
Goodwill Written off |
5,000 |
|
Loss on Sale of Machinery |
2,000 |
10,000 |
|
|
37,000 |
Less: Profit on Sale of Building |
|
(12,000) |
Operating Profit Before Working Capital Change |
|
25,000 |
IT Refund Received |
|
3,000 |
Net Cash Flow from Operating Activities |
|
28,000 |
Illustration 16.10
The following is the position of current assets and current liabilities of a company.
Particulars |
Balance | |
---|---|---|
Opening | Closing | |
Provision for Bad Debts |
5000 |
|
Short-term Loan |
20,000 |
30,000 |
Creditors |
25,000 |
20,000 |
Bills Receivable |
30,000 |
50,000 |
The company incurred a loss of 70,000 during the year 2010. Calculate cash flows from operating activities by indirect method.
Solution
Particulars | ||
---|---|---|
Loss During 2010 |
|
− (70,000) |
Adjustments: |
|
|
(a) Increase in Current Liabilities Bills Receivable |
(20,000) |
|
(b) Decrease in Current Liabilities Creditors |
(5000) |
|
Provision for Bad Debts |
(5000) |
− (30,000) |
Cash Used in Operating Activities |
|
− (1,00,000) |
Here, students should note that net loss is given, instead of net profit. The result is negative. This means (negative cash from operation) that there is net outflow of cash from operating activities.
Short-term Loan: This is a financing activity. Therefore, it has to be shown under cash flow from financing activities.
Increase in short-term loan is ignored.
Adjustments: For sale and purchase of (non-current) fixed assets (as per revised standard):
There are two methods for this:
Illustration 16.11
Particulars | Opening Balance |
Closing Balance |
---|---|---|
P & L Account |
45,000 |
55,000 |
General Reserve |
25,000 |
30,000 |
Provision for Depreciation on Plant |
40,000 |
45,000 |
Outstanding Expenses |
5,000 |
2,000 |
Goodwill |
25,000 |
15,000 |
Sundry Debtors |
60,000 |
50,000 |
An item of plant costing 50,000 having book value of 40,000 was sold for 45,000 during the year.
Solution
Step 1: First Net Profit Before Tax is to be Calculated.
Net Profit for the Year
Difference Between Opening and Closing Balances in the Problem
(i.e. 55,000 − 45,000) |
10,000 |
Adjustment: |
|
Add General Reserve (Difference 30,000 − 25,000) |
5,000 |
Net Profit Before Tax: |
15,000 |
Step 2:
= 45,000 – 40,000
= 5,000
Step 3:
Step 4: Finally, Computation of Cash Flow From Operating Activities Has to be Worked out as Follows:
Particulars | ||
---|---|---|
Net Profit Before Tax |
|
15,000 |
Adjustments: |
|
|
Add: Non-cash Expenses: |
|
|
Depreciation |
15,000 |
|
Goodwill Written off |
10,000 |
25,000 |
|
|
40,000 |
Less: Non-cash Incomes: |
|
|
Profit on Sale of Plant |
|
(5,000) |
Operating Profit Before Working Capital Changes |
|
35,000 |
Add: Decrease in Current Assets Sundry Debtors |
|
10,000 |
|
|
45,000 |
Less: Decrease in Current Liabilities: Outstanding Expenses |
|
(3,000) |
Cash Flows from Operating Activities |
|
42,000 |
Illustration 16.12
Calculate cash flows from operating activities from the following information.
Particulars | 2008 () |
2009 () |
---|---|---|
Debtors |
42,000 |
46,000 |
Prepaid Expenses |
2,000 |
2,700 |
Accrued Income |
1,500 |
1,200 |
Income Revised in Advance |
800 |
1,000 |
Creditors |
26,000 |
29,000 |
Bills Payable |
13,000 |
11,000 |
Outstanding Expenses |
8,000 |
6,000 |
Profit made during 2009 amounted to 1,00,000 after taking into account the following adjustments:
Solution
Cash flow for operating activities
Particulars | ||
---|---|---|
Profit for the Year |
|
1,00,000 |
Items to Be Added Back to Profit |
|
|
Add: Depreciation |
2,900 |
|
Goodwill Amortized |
3,000 |
|
Loss on Sale of Machine |
900 |
6,800 |
|
|
1,06,800 |
Less: Profit on Sale of Investment |
(2,000) |
(2,000) |
Cash Generated from Operation Before Working Capital Changes (Operation Profit) |
|
1,04,800 |
Add : Decrease in Current Assets and Increase in Current Liabilities Accrued Income |
300 |
|
Income Received in Advance |
200 |
|
Creditors |
2,000 |
2,500 |
|
|
1,07,300 |
Less: Increase in Current Assets and Decrease in Current Liabilities Debtors |
(4,000) |
|
Prepaid Expense |
(200) |
|
Bills Payable |
(2,000) |
|
Outstanding Expenses |
(2,000) |
(8,700) |
Net Cash Flows from Operating Activities |
|
98,600 |
Illustration 16.13
The net profit of a company before tax is 12,50,000 as on 31 March 2011 after considering the following.
Depreciation on Fixed Assets |
25,000 |
Goodwill Written off |
15,000 |
Loss on Sale of Machine |
12,000 |
The current assets and current liabilities at the beginning and end of the year were as follows:
Particulars | 31 March 2010 () |
31 March 2011 () |
---|---|---|
Bills Receivables |
25,000 |
15,000 |
Bills Payable |
10,000 |
12,500 |
Debtors |
30,000 |
38,800 |
Stock in Hand |
18,000 |
14,000 |
Outstanding Expenses |
8,000 |
7,000 |
Solution
Calculate cash flow from operating activities:
Students should once again remember the steps in preparing cash flow from operating activities]:
Step 1: |
Net Profit Before Tax is Taken as the Base. |
Step 2: |
Items to be Added Back to the Net Profit have to be written One by One and Add with Net Profit. |
Step 3: |
This Added Value is ‘Operating Profit Before Working Capital Changes. |
Step 4: |
With this, the Following Items to be Added: |
Step 5: |
Then, the following items have to be deducted: |
Step 6: |
Net Result is ‘Net Cash Flow from Operating Activities. |
Particulars | ||
---|---|---|
A: Net Profit Before Tax |
|
12,50,000 |
B: Add: (Items to Be Added Back to Net Profit) |
|
|
Depreciation on Fixed Assets |
25,000 |
|
Goodwill Written off |
15,000 |
|
Loss on Sale of Machine |
12,000 |
52,000 |
C: Operating Profit Before Working Capital Changes (A + B) |
|
13,02,000 |
D: Add: (Decrease in Current Assets and Increase in Current Liabilities) |
|
|
Decrease in Bills Receivables |
9,500 |
|
Decrease in Stock |
4,000 |
|
Increase in Bills Payable |
2,500 |
16,000 |
E: (Deduct) |
|
|
Less: (Increase in Current Assets and Decrease in Current Liabilities) |
|
13,18,200 |
Increase in Debtors |
8,000 |
|
Decrease in Outstanding Expenses |
1,000 |
(9,000) |
F: Net Cash Flow from Operating Activities (C + D − E) |
|
13,09,200 |
There are two categories as follows:
First category: Fixed assets are shown at written down value (WDV). No additional information will be shown:
A public limited company has plant and machinery whose written down value on 1 April 2010 was 7,50,000 and on 31 March 2011 was 9,00,000. Depreciation for the year was 30,000. At the beginning of the year a part of the plant was sold for 20,000, which had written down value of 17,500. Calculate the net cash flow from investing activities.
Solution
Note: Fixed assets are shown at written down value.
Stage 1: Purchasing Amount has to be Calculated.
So, Plant and Machinery A/c has to be Opened.
*1Cash payment to acquire plant and machinery is ascertained as 1,97,500
Stage 2:
Particulars | ||
---|---|---|
Cash Payments to Acquire Plant and Machinery |
(1,97,5000) |
|
Cash Receipts from Sale of Plant and Machinery (Given in Question) |
20,000 |
(1,77,500) |
Cash Flow from Investing Activities |
|
(1,77,500) |
Second category: Fixed assets are shown at cost and accumulated depreciation (separately maintained) or provision for depreciation
This can be explained with the help of following illustration.
Illustration 16.15
From the following information, calculate the cash flow from investing activities.
Particulars | 31.03.2010 |
31.3.2011 |
---|---|---|
Machinery (At Cost) |
5,00,000 |
5,50,000 |
Accumulated Depreciation |
1,00,000 |
1,20,000 |
Patents |
3,00,000 |
1,90,000 |
Additional information:
Solution
Step 1: Profit on Sale of Machinery is to be Calculated.
Step 2:
Step 3:
Step 4:
Step 5:
Particulars | |
---|---|
Inflow from Sale of Machinery |
25,000 |
*1 Outflow on Purchase of Machinery |
(1,00,000) |
*3 Inflow from Sale of Patents |
80,000 |
Net Cash Flow from Investing Activities |
5,000 |
Illustration 16.16
From the following particulars, calculate the cash flows from investing activities.
Purchases |
Sales |
|
---|---|---|
Investments |
3,00,000 |
2,00,000 |
Goodwill |
1,50,000 |
— |
Machinery |
6,50,000 |
2,10,000 |
Patents |
— |
1,00,000 |
Dividend received on shares held as investment 30,000. Interest received on debentures held as investment 40,000. A building purchased for investment purposes (out of surplus funds) was let out and rent proceeds received thereby 1,20,000.
Solution
This is a different problem.
Particulars | |
---|---|
Investments Purchased |
(3,00,000) |
Proceeds from Sale of Investments |
2,00,000 |
Goodwill Purchased |
(1,50,000) |
Machinery Purchased |
(6,50,000) |
Proceeds from Sale of Machinery |
2,10,000 |
1,00,000 |
|
Interest Received on Debentures |
40,000 |
Dividend Received on Shares |
30,000 |
Rent Received |
1,20,000 |
Net Cash Flow from Investing Activities |
(4,00,000) |
Illustration 16.17
A company has an investments of 40,000 at the beginning of the year and 30,000 at the end of the year. During the year the company had sold 50% of its investments held at the beginning of the year at a profit of 10,000. Compute cash flow from investing activities.
Solution
Step 1: |
First, Cost of Sales is to be Calculated: 50% of the Investments Held at the Beginning = 50/100 × 40,000 = 20,000 |
|
With this, Profit has to be Added to arrive at cash inflow from sale of investment. So sale of investment = 20,000 + 10,000 = 30,000. |
Step 2: |
Next: Investment account is to be prepared to compute outflow on purchase of investment (i.e. the balancing figure in this account). |
Step 3:
Particulars | ||
---|---|---|
Inflow from Sale of Investment |
|
|
Cost of Investment Sold |
20,000 |
|
Add: Profit on Sale |
10,000 |
30,000 |
Less: Outflow on Purchase of Investment |
|
(10,000) |
Net Cash flow from Investing Activities |
|
20,000 |
Illustration 16.18
Calculate cash flow from investing activities.
Particulars | Opening () |
Closing () |
---|---|---|
Machinery (At Cost) |
6,00,000 |
6,25,000 |
Accumulated Depreciation |
1,10,000 |
1,25,000 |
During the year, one of the machines costing 60,000 with accumulated depreciation of 35,000 was sold for 30,000.
Solution
Step 1: |
|
|
|
Profit on Sale of Machinery has to be Calculated. |
|
|
Profit on Sale of Machinery |
= Sale Price – Book Value |
|
Sale Price is Given |
= 30,000 |
Step 2: |
Book Value is to be Found Out. |
|
|
Book Value |
= (Cost – Accumulated Depreciation) |
|
|
= ( 60,000 – 35,000) |
|
|
= 25,000 |
Step 3: |
Profit on Sale of Machinery |
= 30,000 – 25,000 |
|
|
= 5,000 |
Step 4: |
Then Machinery Account is to be Prepared. |
|
Step 5: Accumulated depreciation account is to be prepared.
Step 6: Cash flow from investing activities is prepared.
Particulars | |
---|---|
Inflow from Sale of Machinery |
30,000 |
Outflow from Purchase of Machinery (Bal. Fig. in Machinery A/c) |
(85,000) |
Net Cash Flow from Investing Activities |
(55,000) |
Activities that result in change in the size and composition of owners’ capital and borrowing of the enterprises are termed as financing activities.
Items included in financing activities are as follows:
Note:
Illustration 16.19
Calculate the cash flow from financing activities of a concern from the following information.
Particulars | 31 March 2008 |
31 March 2009 |
---|---|---|
Equity Share Capital |
5,00,000 |
6,75,000 |
9% Debentures |
2,00,000 |
1,50,000 |
Securities Premium |
50,000 |
70,000 |
Interest paid on debentures = 18,000
Solution
Note:
Particulars | ||
---|---|---|
Cash Receipts from Issue of Shares |
1,75,000 |
|
Add: Proceeds from Premium |
20,000 |
1,95,000 |
Redemption of Debentures |
(50,000) |
|
Interest Paid on Debentures |
(18,000) |
(68,000) |
Net Cash Flow from Financing Activities |
|
1,27,000 |
Illustration 16.20
A public limited company extends the following information. Calculate the net cash flow from financing activities.
Particulars | ||
---|---|---|
Equity Shares Capital |
20,00,000 |
30,00,000 |
12% Debentures |
1,00,000 |
— |
9% Debentures |
— |
3,00,000 |
Additional information:
Solution
Note:
So, care should be taken before ascertaining the cash flow from financing activities, whether those items that form part of financing activities should be included or not.
Particulars | |
---|---|
Cash Proceeds from the Issue of 9% Debentures |
3,00,000 |
Payments on Redemption of 12% Debentures |
(1,00,000) |
(12,000) |
|
Payment of Dividend |
(75,000) |
Net Cash Flow from Financing Activities |
1,13,000 |
This depends on the following:
↓
↓
↓
These can be represented by a tabular column as follows:
To be added back to current years profit to ascertain cash flow from operating activity.
To be treated as financing activity.
Illustration 16.21
From the following information, calculate the cash flow from (i) investing activities and (ii) financing activities.
Particulars | 1 April 2010 | 31 March 2011 |
---|---|---|
() | () | |
Furniture (At Cost) |
25,000 |
35,000 |
Accumulated Depreciation on Furniture |
5,000 |
8,000 |
Capital |
2,00,000 |
2,75,000 |
Loan |
50,000 |
30,000 |
During the year 2010–11, furniture costing 7,000 was sold at a profit of 2,500.
Depreciation on furniture charged during the year amounted to 6,000.
Solution
Step 1: First, cash flow from financing activities is to be computed as follows:
Particulars | |
---|---|
Cash Inflow by Issue of Fresh Capital {i.e. Increase in Capital = 2,75,000 – 2,00,000} |
75,000 |
Cash Outflow on Repayment of Loan {i.e. Loan Decreased: 50,000 – 30,000} |
(20,000) |
Net Cash from Financing Activities |
55,000 |
Next, Furniture Account and Accumulated Depreciation Accounts have to be Computed.
Sale Price = Cost – Accumulated Depreciation + profit on Sale
Step 2:
Step 3:
Step 4: Finally, Cash Flow From Investing Activities has to be Ascertained.
Particulars | |
---|---|
Cash Inflow by Sale of Furniture *1 |
6,500 |
Cash Outflow on Purchase of Furniture *3 |
(17,000) |
Net Cash Flow from Investing Activities |
(10,500) |
Note: Here, negative net cash flow indicates the net cash used in investing activities.
Illustration 16.22
An extract from the balance sheets of ABC Ltd.
You are required to prepare the cash flow statement for the year ended on 31 March 2011.
Solution
Computation of cash flow statement of ABC Ltd. for the year ended on 31 March 2011
A: Cash Flow from Operating Activities | ||
---|---|---|
Closing Balance as per P & L A/c |
10,00,000 |
|
Less: Opening Balance as per P & L A/c |
7,00,000 |
|
Net Profit |
3,00,000 |
|
Add: Proposed Dividend During the Year |
5,00,000 |
|
Net Cash from Operating Activities |
|
8,00,000 |
B: Cash Flow from Financing Activities |
||
Final Dividend Paid |
4,00,000 |
|
(i.e.) Proposed Dividend (Previous Year) Payable |
(70,000) |
3,30,000 |
Net Cash Used in Financing Activities |
|
(3,30,000) |
Illustration 16.23
An extract from the balance sheets of XY Ltd. is as follows.
Additional information:
The final dividend on preference shares and an interim dividend of 60,000 on equity shares were paid on 31 March 2011.
How these items will be recorded in the cash flow statement?
Solution
A: Cash Flow from Operating Activities |
|
|
Closing Balance as per Profit and Loss A/c |
|
5,50,000 |
Less: Opening Balance as per Profit and Loss A/c |
|
3,00,000 |
Net Profit |
|
2,50,000 |
Add: Proposed Dividend During the year 2010–11 |
2,50,000 |
|
Dividend Paid on Pref. Shares. |
60,000 |
|
Interim Dividend Paid |
60,000 |
3,70,000 |
Net Cash from Operating Activities |
|
6,20,000 |
B: Cash Flow from Financing Activities: |
|
|
Final Dividend Paid on Equity Shares ( 1,75,000 − 55,000) |
|
(1,20,000) |
Final Dividend Paid on Preference Shares |
|
(60,000) |
Interim Dividend Paid on Equity Shares |
|
(60,000) |
Net Cash Used in Financing Activities |
|
(2,40,000) |
Illustration 16.24
An extract from the balance sheet of Renu Ltd. is as follows.
Solution
Step 1:
Step 2:
Step 3:
Step 4:
An Extract of Cash Flow Statement for the Year Ended on 31 March 2011.
1. Cash Flow Operating Activities |
|
Closing Balance as per Profit and Loss A/c |
2,50,000 |
Less: Discount Balance as per Profit and Loss A/c |
(2,00,000) |
Add: Discount on Issue of Shares (from *1) |
1,00,000 |
Interest on Debentures ( 1,50,000 × 10/100) |
1,50,000 |
Net Cash from Operating Activities |
3,00,000 |
2. Cash Flow from Financing Activities |
|
Proceeds from Issue of Debentures (from *3) |
4,25,000 |
Illustration 16.25
An extract from the balance sheet of Verma Ltd. is as follows.
Additional information:
Discount on the issue of debentures written off during the year 2010–11 was 25,000.
You are required to depict the related items in the cash flow statement.
Solution
Step 1:
Step 2:
Step 3:
Step 4: An Extract of Cash Flow Statement for the Year Ended on 31 March 2011.
|
|
1. Closing Balance as per Profit and Loss A/c |
2,25,000 |
Less: Opening Balance as per Profit and Loss A/c |
(1,50,000) |
Add: Discount on Issue of Shares *1 |
70,000 |
Discount on Issue of Debentures *2 |
75,000 |
Interest on Debentures |
1,50,000 |
Net Cash from Operating Activities |
3,70,000 |
2. Cash Flow from Operating Activities |
|
Proceeds from Issue of Debentures |
4,25,000 |
Interest Paid on Debentures |
(1,30,000) |
Net Cash from Financing Activities |
2,95,000 |
Illustration 16.26
From the following information, prepare a cash flow statement for the year ending on 31 March 2011.
Depreciation provided during the year 2010–11 = 10,000
[B.Com. (Madras)—Modified]
Solution
Stage I: Cash flow from operating activities has to be calculated first.
Step 1: For this profit as per balance sheet has to be taken as base figure ( 60,000 – 50,000)
Step 2: General Reserve ( 10,000 – 4,000) has to be added
Step 3: Here, Depreciation and Goodwill,
Step 4: With this
Step 5: Result—net cash from operating activities
Stage II (B) Cash flow from investing activities has to be calculated.
Here, in this question, cash outflows occur on purchase of machine and building
Step 1: *Accrual cash flow—amount spent on purchase of machineries—is ascertained by separately preparing machinery account and the balancing figure from that account has to be transferred here.
Step 2: Purchase of Building
Note: The values are written without brackets—which means outflow of cash.
Stage III (C) Cash flow from financing activities has to be computed.
Step 1: Here, in the problem, cash flow or share capital
Stage IV: Net increase in cash and cash equivalents is to be computed as
Stage V: With this
Add cash and cash equivalents at the beginning.
Stage VI: Finally, we arrive at
Cash and cash equivalents at the end.
These are represented in the following format:
B: Cash Flow from Investing Activities | ||
---|---|---|
Purchase of Machine (Transferred from Machinery A/c) (Step 1) |
(59,000) |
|
Purchase of Building (90,000 . 40,000) (Step 2) |
(50,000) |
(1,09,000) |
Net Cash Used in Investing Activities |
|
|
C: Cash Flow from Financing Activities |
|
|
Issue of Share Capital (Stage III, Step 1) |
|
80,000 |
A – B + C → Net Increase in Cash and Cash Equivalents (Stage IV) |
|
10,000 |
Cash and Cash Equivalents at the Beginning (Stage V) (Given—2007) |
|
20,000 |
Cash and Cash Equivalents at the End (Stage VI) |
|
30,000 |
Stage I:Cash flow from operating activities.
Step 1: Net profit before tax is taken as base, instead of showing separately the closing balances and opening balances of P & L A/c straight away. Net profit (closing balance – opening balance) amount can be recorded and with this transfer to general reserve is added).
Step 2: Add:
Step 3: Figure arrived at this stage is termed as operating profit before working capital changes.
Step 4: With this, the following items have to be added. Add:
Step 5: Less: following items have to be deducted.
Step 6: Figure arrived at this stage is termed as ‘net cash flow from operating activities’. Now we have to go to the next stage.
Stage II: Cash flow from investing activities
Purchases of plant, machinery, land and buildings have to be recorded here.
Important note: If depreciation amount is given in additional information, separate account (plants A/c – building A/c) has to be prepared to ascertain the value of its purchase, which is cash flow from investing activities.
(In this stage such items, as described above, are to be recorded and the sum of all the items to be shown within brackets, which means that due to investing activities, cash outflow actually place).
Figure arrived is termed as ‘net cash from financing activities’.
Stage III: Cash flow from financing activities.
Step 1: Issue of share capital to be recorded.
Step 2: Less: If any redemption, such amount has to be recorded and deducted from Step 1.
Step 3: Figure arrived at this stage is termed as ‘net cash from financing activities’.
Stage IV: Net increase and decrease in cash and cash equivalents
Stage V: Cash and cash equivalents at the beginning of the year to be added.
Stage VI: Cash and cash equivalents at the end of the year to be recorded.
Note: This is a simplified form. Only one or two items are shown. Students should practice with this first and then proceed to all the other items mentioned in the standardized format as prescribed by [(AS-3)].
Illustration 16.27
The following is the financial position as on 31 March.
During the year 60,000 was paid as dividend. You are required to prepare cash flow statement as per revised accounting standard [(AS)-3 (Revised)].
Solution
First, net profit has to be calculated because all adjustments have to be carried on unit net profit as base.
|
|
Profit as on 31 March 2011 |
: 1,60,000 |
Profit as on 31 March 2010 |
: 1,40,000 |
(Difference) Profit for the Year |
: 20,000 |
Add: Dividend Paid During the Year |
: 60,000 |
*1Net Profit Before Tax and Extraordinary Items |
: 80,000*1 |
Particulars | ||
---|---|---|
A: Cash Flow from Operating Activities |
|
|
*1 Net Profit Before Tax and Extraordinary Items (as Calculated Above) |
*180,000 |
|
Add: Depreciation |
1 0,000 |
|
Operating Profit Before Working Capital Changes |
90,000 |
|
Add: Decrease in Stock |
14,000 |
|
Increase in Current Liabilities |
20,000 |
|
Increase in Debtors |
(5,000) |
|
Net Cash from Operating Activities |
|
1,19,000 |
B: Cash Flow from Investing Activities |
|
|
Purchase of Building |
(20,000) |
|
Purchase of Land |
(20,000) |
|
Purchase of Machinery |
(30,000) |
|
Net Cash Used in Investing Activities |
|
(70,000) |
C: Cash Flow from Financing Activities |
|
|
Proceeds of Loan from Ram Ltd. |
40,000 |
|
Repayment of Bank Loan |
(30,000) |
|
Payment of Dividend |
(60,000) |
(50,000) |
Net Decrease in Cash and Cash Equivalents |
|
(1,000) |
Cash and Cash Equivalents at the Beginning |
|
12,000 |
Cash and Cash Equivalents at the End |
|
11,000 |
Notes:
Hint 1: Instead of profit/loss, capital alone may be given in the problem. In such cases, profit is arrived at as:
|
|
|
Capital at the End of the Period: |
… |
xx |
Less: Capital at the Beginning of the Period: |
… |
xx |
Profit for the Year: |
… |
xx |
Hint 2: In case, if capital at the beginning and at the end of the period is given, students have to prepare capital account and the balancing figure is taken as ‘drawings’.
Calculation of Drawings: |
|
Opening Capital: |
… |
Add: Net Profit: |
… |
Less: Closing Profit: |
… |
Drawings: |
… |
This amount has to be included in cash flow financing activities under ‘drawings’ |
Hint 3:Loss on sale of fixed assets is calculated as follows:
Loss on sale of fixed assets: cost – selling price
And, if in case of any depreciation: cost – accumulated depreciation – selling price
Hint 4:Provision for taxation
Case 1: Item, ‘provision for taxation’ appears on the liabilities side of previous year’s balance sheet.
Case 2: This item ‘provision for taxation’ appears on the liabilities side of the currents year’s balance sheet.
Hint 5: Dividend paid during the year:
Interim dividend for the year is calculated as follows:
Hint 6: If appropriate adjustments have to be made for both provision for tax and interim dividend to arrive at net profit before tax, then the following adjustment are to be made:
Profit at the End of the Period (Closing): |
|
Less: Profit at the Beginning (Opening): |
— |
Profit of the year: |
— |
|
xx |
Appropriations: |
|
Add: 1. Interim Dividend Paid: |
— |
2. Provision for Tax: |
— |
Profit Before Tax: |
xx |
Illustration 16.28
From the following information, prepare a cash flow statement as on 31 March 2009.
Depreciation provided during the year on machine was 10,000.
Solution
Illustration 16.29
From the following balance sheet of Raja Ltd., prepare a cash flow statement as on 31 December 2011.
Depreciation charged on plant was 10,000 and on building was 60,000.
Solution
As depreciation is given in additional information plant A/c and building A/c have to be prepared separately to ascertain the value of their purchase, which are cash flow from investing activities.
Net Profit Before Taxation | ||
---|---|---|
Closing Balance of P & L A/c |
24,000 |
|
Add: Transfer of General Reserve |
15,000 |
|
|
39,000 |
|
Less: Opening Balance of P & L A/c |
15,000 |
24,000 |
Note:Instead of showing separately closing and opening balance adjustments, straight away net profit can be found as (closing balance – opening balance) as 9000 and with this transfer to general reserve is added.
A: Net Profit Before Tax and Extraordinary Items |
||
Adjustment for |
|
|
Depreciation on Plant |
10,000 |
|
Depreciation on Building |
60,000 |
|
Goodwill Written off |
1 6,000 |
86,000 |
Operation Profit Before Working Capital Changes |
|
1,10,000 |
Adjustments for : |
|
|
Add: Increase in Creditors |
12,000 |
|
Less: Increase in Debtors |
(35,500) |
|
Increase in Stock |
(5,000) |
(28,500) |
Net Cash from Operating Activities |
|
81,500—A |
B: Cash Flows from Investing Activities |
|
|
Purchase of Plant |
70,000 |
|
Purchase of Building |
40,000 |
|
Net Cash in Investing Activities |
|
(1,10,000)—B |
C: Cash Flow from Financing Activities |
|
|
Issue of Share Capital |
50,000 |
|
Redemption of 12% Pref. Share Capital |
(25,000) |
|
Net Cash from Financing Activities |
|
25,000—C |
Net Decrease in Cash and Cash Equivalents (A + B + C) |
|
(3,500) |
Cash and Cash Equivalents at the Beginning of the Year |
|
(12,500) |
Cash and Cash Equivalents at the End of the Year |
|
9,000 |
Illustration 16.30
From the following balance sheet of Vivek Ltd., prepare a cash flow statement.
Depreciation charged on plant was 30,000 and on building was 50,000.
Solution
B: Cash Flows from Investing Activities
Plant Purchased |
|
(60,000) |
Building Purchased |
|
(30,000) |
Net Cash in Investing Activities |
|
90,000)—B |
C: Cash Flow from Financing Activities |
|
|
Proceeds from Issue of Equity Shares |
|
50,000 |
Redemption of Pref. Shares |
|
(10,000) |
Net Cash from Financing Activities |
|
40,000—C |
D: Net Increase in Cash and Cash Equivalents (A + B + C) |
|
3,000 |
( 52,000 + ( −90,000) + 40,000) |
|
|
E: Cash and Cash Equivalents at the Beginning of the Year: Cash-in-Hand |
|
15,000 |
Cash and Cash Equivalents at the End of the Year |
|
17,000 |
Illustration 16.31
What is meant by investing activities? From the following particulars prepare cash flows from investing activities.
|
Purchased |
Sold |
1. Machinery |
4,00,000 |
2,00,000 |
2. Investments |
2,00,000 |
3,00,000 |
1,00,000 |
|
|
4. Patents |
|
1,50,000 |
5. Interest Received or Debentures Held as Investments |
10,000 |
|
6. Dividend Received on Shares Held as Investments |
5,000 |
|
7. A Plot of Land Was Purchased out of Surplus Funds for |
20,000 |
|
Investment Purposes and Was Let out for Commercial Use and Rent Received
Solution
The acquisition and disposal of long-term assets (not included in cash equivalents) is called investing activities.
Particulars | |
---|---|
Purchase of Machinery |
(4,00,000) |
Proceeds from Sale of Machinery |
2,00,000 |
Purchase on Investments |
(2,00,000) |
Proceeds from Sale of Investments |
3,00,000 |
Purchase of Goodwill |
(1,00,000) |
Proceeds from Sales of Patents |
1,50,000 |
Interest Received |
10,000 |
Dividend Received |
5,000 |
Rent Received |
20,000 |
Net Cash Used in Investing Activities |
(15,000) |
Note: Figures within the brackets means items that are to be deducted. This comes to be 4,00,000, 2,00,000, 1,00,000 = 7,00,000
This has to be deducted from ( 2,00,000 + 3,00,000 + 1,50,000 + 10,000 + 5,000 + 20,000 = 6,85,000. Again (– 7,00,000 + 6,85,000) = net result (– 15,000). So cash is used. Cash flows out on investing activities.
Illustration 16.32
Calculate cash flows from operating activities from the following information.
Particulars | 2010 |
2011 |
---|---|---|
Stock |
60,000 |
50,000 |
Debtors |
25,000 |
23,000 |
Creditors |
32,000 |
28,000 |
Expenses Outstanding |
3,500 |
4,500 |
Bills Payable |
35,000 |
22,000 |
Accrued Income |
8,000 |
9,000 |
Profit and Loss A/c |
80,000 |
90,000 |
Solution
Calculation of Net Cash Flows from Operating Activities
Particulars | ||
---|---|---|
Profit for the Year (Closing – Opening) |
|
10,000 |
Decrease in Stock |
10,000 |
|
Decrease in Debtors |
2,000 |
|
Decrease in Creditors |
(4,000) |
|
Increase in Expenses Outstanding |
1,000 |
|
Increase in Accrued Income |
(1,000) |
|
Decrease in Bills Payable |
(13,000) |
(5,000) |
Net Cash Flow from Operating Activities |
|
5,000 |
Illustration 16.33
From the following information prepare a cash flow statement.
|
|
Opening Cash Balance |
10,000 |
Closing Cash Balance |
12,000 |
Decrease in Debtors |
5,000 |
Increase in Creditors |
7,000 |
Sale of Fixed Assets |
20,000 |
Redemption of Debtors |
50,000 |
Net Profit for the Year |
20,000 |
Solution
Cash Flow Statement for the Year Ended
Particulars | ||
---|---|---|
A: Cash Flows from Operating Activities |
|
|
Net Profit for the Year |
20,000 |
|
Add: Decrease in Debtors |
5,000 |
|
Increase in Creditors |
7,000 |
|
Net Cash Flows from Operating Activities |
|
32,000—A |
B: Cash Flows from Investing Activities |
|
|
Sale of Fixed Assets |
20,000 |
|
Net Cash from Investing Activities |
|
20,000—B |
C: Cash Flows from Financing Activities |
|
|
Redemption of Debtors |
(50,000) |
|
Net Cash from Financing Activities |
|
(50,000)—C |
D: Net Increase in Cash and Cash Equivalents (A + B + C) |
|
2,000 |
(32,000 + 20,000 − 50,000) |
|
|
E: Cash and Cash Equivalents at the beginning |
|
10,000 |
F: Cash and Cash Equivalents at the End of the Period |
|
12,000 |
Illustration 16.34
Prepare a cash flow statement on the basis of the information given in the balance sheet of P.S. Ltd.
Solution
Particulars | ||
---|---|---|
A: Cash Flows from Operating Activities |
|
|
Closing Balance of General Reserve |
70,000 |
|
Less: Operating Balance of General Reserve |
(50,000) |
|
Net Profit: (Before Tax and Extraordinary Items) |
|
20,000 |
(Note: Net Profit Is Not Disclosed in the Balance Sheet. Only General Reserve |
|
|
Appears Here) |
|
|
Add: Items to be Added: |
|
|
Amortization of Goodwill |
8,000 |
|
Investment on Long-term Loan (Debtors = 1,00,000 × 12/100 × 1) |
12,000 |
20,000 |
Operating Profit Before Working Capital Charges |
|
40,000 |
Add: Decrease in Current Assets and Increase in Current Liabilities: |
|
|
Increase in Creditors |
20,000 |
|
Increase in Bills Payable |
80,000 |
1,00,000 |
Less: Increase in Current Assets and Decrease in Current Liabilities: |
|
|
Decrease in Outstanding Expenses |
(5,000) |
|
Increase in Debtors |
(20,000) |
|
Increase a Stock |
(20,000) |
(45,000) |
Net Cash from Operating Activities |
|
95,000—A |
B: Cash Flows from Investing Activities |
|
|
Purchase of Land and Building |
(80,000) |
|
Purchase of Machinery |
(30,000) |
(1,10,000) |
Net Cash Used in Financing Activities |
|
(1,10,000)—B |
C: Cash Flows From Financing Activities |
|
|
Proceeds From Equity Shares |
50,000 |
|
Payment of Long Term (Debenture Redeemed) |
(20,000) |
|
Payment of Interest on Debtors |
(12,000) |
18,000 |
Net Cash from Financing Activities |
|
18,000—C |
D: Net Increase in Cash and Cash Equivalents (A + B + C) |
|
3,000 |
(95,000 − 1,10,000 + 18,000) |
|
|
E: Cash and Cash Equivalents at the Beginning Cash in Hand |
|
15,000 |
F: Cash and Cash Equivalents at the End of the Period |
|
18,000 |
Illustration 16.35
Prepare a cash flow statement of Bulbul Ltd. on the basis of the information given in the balance sheets.
Solution
Particulars | ||
---|---|---|
A: Cash Flows from Operating Activities: |
|
|
Closing Balance of General Reserve |
1,80,000 |
|
Less : Operating Balance of General Reserve |
(1,00,000) |
|
Net Profit Before Tax |
|
80,000 |
Add: Items to Be Added: |
|
|
Amortization of Goodwill |
20,000 |
|
Invest on Debenture |
24,000 |
44,000 |
Operating Profit Before Working Capital Charges |
|
1,24,000 |
Add: Decrease in Current Assets and Increase in Current Liabilities: |
|
|
Decrease in Stock |
1,20,000 |
|
Increase in Creditors |
20,000 |
|
Increase in Outstanding Expenses |
10,000 |
1,50,000 |
|
|
2,74,000 |
Less: Increase in Current Assets and Decrease in Current Liabilities: |
|
|
Increase in Debtors |
(10,000) |
|
Decrease in Bills Payable |
(5,000) |
(15,000) |
Cash Generated from Operation: |
|
2,59,000 |
Less Income Tax Paid |
|
— |
Cash from Operating Activities |
|
2,59,000 |
B: Cash Flows from Investing Activities: |
|
|
Purchase of Land |
(3,00,000) |
|
Purchase of Machinery |
(10,000) |
(3,10,000) |
Net Cash Used in Investing Activities |
|
(3,10,000) |
C: Cash Flows from Financing Activities: |
|
|
Proceeds from Issue of Equity Shares |
1,00,000 |
|
Payment for Debentures (Redemption) |
(50,000) |
|
Payment of Interest on Debentures |
(24,000) |
26,000 |
Net Cash from Financing Activities |
|
26,000 |
D: Net Increase/Decrease in Cash and Cash Equivalents (A − B + C) |
|
25,000 |
( 2,59,000 − 3,10,000 + 26,000) |
|
|
E: Cash and Cash Equivalents at the Beginning (Cash) |
|
10,000 |
F: Cash and Cash Equivalents at the End |
|
35,000 |
Illustration 16.36
The following balances appeared in plant A/c and accumulated depreciation A/c in the books of Bhart Ltd.
|
As on 31 March 2010 |
As on 31 March 2011 |
Plant |
7,50,000 |
9,70,000 |
Accumulated Depreciation |
1,80,000 |
2,40,000 |
Additional information:
Plant costing 1,45,000 accumulated depreciation thereon 70,000 was sold for 35,000. You are required to do the following:
Solution
Note:
(Model: Both direct and indirect methods—preparation of cash flow statement)
Illustration 16.37
Comparative balance sheets for 2009 and 2010 and income statement of for 2010 of PQR Ltd. are presented as follows.
2010 | 2009 | |
---|---|---|
Assets: |
|
|
Cash |
27,000 |
36,000 |
Short-term Investments |
6,000 |
3,000 |
2,85,000 |
2,37,000 |
|
Provision for Doubtful Debts |
(9,000) |
(6,000) |
Inventory |
3,09,000 |
2,76,000 |
Prepaid Expenses |
18,000 |
15,000 |
Land |
2,07,000 |
1,98,000 |
Machinery and Equipment |
5,16,000 |
4,68,000 |
Provision for Depreciation |
(3,39,000) |
(3,06,000) |
|
10,20,000 |
9,21,000 |
Liabilities: |
|
|
Creditors |
1,98,000 |
2,34,000 |
Dividends Payable |
6,000 |
— |
Income Tax Payable |
9,000 |
15,000 |
Long-term debt |
2,25,000 |
1,26,000 |
Equity Share Capital |
78,000 |
78,000 |
P & L Appropriation Account |
5,04,000 |
4,68,000 |
|
10,20,000 |
9,21,000 |
Particulars | |
---|---|
Net Sales Revenue |
18,00,000 |
Cost of Good Sold |
(15,00,000) |
Gross Margin |
3,00,000O |
Operating Expenses |
(1,98,000) |
Operating Income |
1,02,000 |
Indirect Expenses |
(12,000) |
Income Before Tax |
90,000 |
Lawsuit Compensation |
15,000 |
|
1,05,000 |
Income Tax |
(51,000) |
Net Income |
54,000 |
The following additional information is available:
Instructions:
Solution
I—Indirect Method
Particulars | ||
---|---|---|
A: Cash Flows from Operating Activities: |
|
|
Net Income Before Tax and Extraordinary Items Adjustments for: |
90,000 |
|
Depreciation |
33,000 |
|
Interest Expense |
12,000 |
|
Provision for Doubtful Debts |
3,000 |
|
Operating Profit Before Working Capital Changes |
1,38,000 |
|
Increase in Debtors |
(48,000) |
|
Increase in Inventories |
(33,000) |
|
Increase in Prepaid Expenses |
(3,000) |
|
Decrease in Creditors |
(36,000) |
|
Cash Generated from Operations |
18,000 |
|
Taxes Paid |
(57,000) |
|
Cash Flow from Extraordinary Item |
(39,000) |
|
Law Suit Compensation |
15,000 |
|
Net Cash Used in Operating Activities |
|
(24,000) |
B: Cash Flows from Investing Activities: |
|
|
Purchase of Land |
(9,000) |
|
Purchase of Equipment |
(18,000) |
|
Net Cash Used in Investing Activities |
|
(27,000) |
C: Cash Flows from Financing Activities: |
|
|
Proceeds from Long-term Borrowings |
69,000 |
|
Dividends Paid |
(1 2,000) |
|
Interest Paid |
(1 2,000) |
|
Net Cash from Financing Activities |
|
45,000 |
Net Decrease in Cash and Cash Equivalents: (A + B + C) |
|
(6,000) |
Cash and Cash Equivalents at the Beginning |
|
39,000 |
Cash and Cash Equivalents at the End |
|
33,000 |
Significant Non-cash Transaction |
||
Purchase of Equipment for Long-term Note: 30,000 |
II—Direct Method
Particulars | ||
---|---|---|
A: Cash Flows from Operating Activities |
|
|
Cash Receipts from Customers |
1752,000 |
|
Cash Paid to Suppliers and Employees |
17,34,000 |
|
Cash Inflows from Operations |
18,000 |
|
Income Tax Paid |
(57,000) |
|
Cash Flow from Extraordinary Item |
(39,000) |
|
Law Suit Compensation |
15,000 |
|
Net Cash Used in Operating Activities |
|
(24,000) |
B: Cash Flows from Investing Activities: |
|
|
Purchase of Land |
(9,000) |
|
Purchase of Equipment |
(18,000) |
|
Net Cash Used in Investing Activities |
|
(27,000) |
C: Cash Flows from Financing Activities: |
|
|
Proceeds from Long-term Borrowings |
69,000 |
|
Dividends Paid |
(12,000) |
|
Interest Paid |
(12,000) |
|
Net Cash from Financing Activities. |
|
45,000 |
Net Decrease in Cash and Cash Equivalents (A + B + C) |
|
(6,000) |
Cash and Cash Equivalents at the Beginning |
|
29,000 |
Cash and Cash Equivalents at the End |
|
33,000 |
Significant Non-cash Transaction
Purchase of Equipment for Long-term Note 30,000
Calculations | |
---|---|
1. Calculation of Cash Receipts from Customers: |
|
Sales Revenue |
18,00,000 |
Add: Sundry Debtors at the Beginning |
2,37,000 |
|
20,37,000 |
Less: Sundry Debtors at the End |
2,85,000 |
|
17,52,000 |
2. Calculation of Cash Paid to Suppliers and Employees: |
|
Cost of Goods Sold |
15,00,000 |
Operating Expenses |
1,62,000 |
[ 1,98,000 − 33,000 (Depreciation) − 3,000 (Provision for Doubtful Debts) |
|
|
16,62,000 |
Add: Creditors at the Beginning |
|
Payments at the End |
2,34,000 |
Inventories at the End |
18,000 |
|
22,23,000 |
Less: Creditors at the End |
(1,98,000) |
Payments at the Beginning |
(15,000) |
Inventories at the Beginning |
(2,76,000) |
|
17,34,000 |
3. Calculation of IT Paid: |
|
Income Tax Expense |
51,000 |
Add: IT Liabilities at the Beginning |
15,000 |
|
66,000 |
Less: IT Liabilities at the End |
(9,000) |
|
57,000 |
4. Calculation of Dividend Paid: |
|
Amount Appropriated |
18,000 |
Less: Liability at the End |
6,000 |
|
12,000 |
Cash flow statement depicts sources of cash inflows and transactions of cash outflows during a period. It is a statement indicating flow of cash and cash equivalents during a period.
Now, preparation of cash flow statement is mandatory for all the companies. It is also mandatory for all business entities, which has turnover of more than 50 crores in a financial year.
Main ‘sources’ of cash inflows are the following:
Main ‘uses of cash’ (or) cash outflows are as follows:
The cash flow statement shows cash flows (inflow and outflow) in terms of three components as per accounting standard-3: (i) operating, (ii) investing and (iii) financing activities.
The cash flow statement shows the net increase/ decrease of cash and cash equivalents under each activity individually and collectively.
Cash flows from operating activities result from the major revenues producing activities of a business concern. The major operating items are: cash inflow (cash sales), cash received from debtors, cash proceeds from extraordinary items, royalty, commission, etc.) and cash outflow (cash purchases, cash paid to suppliers and employees and cash operating expenses, income tax, etc.)
Major investing activities are cash inflows: sale of fixed assets, investments, interest and dividends, received and cash outflows: purchase of fixed assets and investments.
Major financing activities are cash inflows: issue of shares in cash, issue of debentures, proceeds from long-term borrowings and cash outflows; redemption of preference shares/debentures, repayment of loans, buy-back of equity shares, payment of interest and dividend, etc.
Importance of (activities) cash flow statement—operating activities—net cash flow is an indicator to assets cash generation and to forecast future cash flows.
Investing activities: To study the net result of the amount spent on investment, usefulness of such expenditure and thereby the future income from such investments.
Financing activities: To assess claims on future cash flows.
Important steps to prepare cash flow statement:
Step 1: |
Cash flow from operating activities is computed either by direct or indirect method. |
Step 2: |
Net cash flow from investing activities is calculated. |
Step 3: |
Net cash flow from financing activities is determined. |
Step 4: |
Net flow, i.e. net increase or decrease in cash or cash equivalents is determined from Steps 1–3. |
Step 5: |
Cash and cash equivalent balance at the beginning of the period is added to the net cash flows determined in Step 4. |
Step 6: |
The amount arrived in Step 4 must be equal to cash and cash equivalents balance at the end of the year. |
Cash Equivalents: Short-term, highly liquid investments that are readily convertible into known amount of cash.
Cash Flow Statements: A statement that shows the flow of cash and equivalents during a period.
Cash Flow: Inflow and outflow of cash and equivalents.
Cash: Cash constitutes cash on banks.
Debenture: A debt security with a general claim against all assets.
Debtor: A person who owes money to another; (or) a business enterprise that owes money to another.
Direct Method: The method that calculates net cash provided by operating activities.
Financing Activities: Activities that result in change in size and composition of the owners’ capital and borrowing of the enterprises.
Indirect Method: The method that adjusts net income to reveal only.
Investing Activities: Activities that result in change in size and composition of fixed assets and long-term investments.
Operating Activities: Principal revenue-producing activities of business enterprises that are not investing and financing activities.
I: State whether the following statements are true or false
Answers:
II: Fill in the blanks with apt word(s)
Answers:
III: Multiple choice questions—Choose the correct answer
Answers:
1. (a) |
2. (b) |
3. (c) |
4. (a) |
5. (c) |
6. (a) |
7. (a) |
8. (b) |
9. (c) |
10. (a) |
1. Calculate cash flow from operating activities from the following information.
Particular |
2010 |
2011 |
|
||
Stock |
60,000 |
50,000 |
Debtors |
25,000 |
23,000 |
Creditors |
32,000 |
28,000 |
Expenses |
3,500 |
4,500 |
Outstanding |
|
|
Bills Payable |
35,000 |
22,000 |
Accrued Income |
8,000 |
9,000 |
Profit and Loss A/c |
80,000 |
90,000 |
[Ans.: Net cash flow from operating activities: 5,000]
2. X Ltd. made a profit of 1,00,000 after charging depreciation of 20,000 on assets and a transfer to general reserve of 30,000. The goodwill written off was 7,000 and the gain on sale of machineries was 3,000. The other information available: charges in the value of current assets and current liabilities. At the end of the year debtors show an increase of 6,000; creditors an increase of 10,000. Prepaid expenses and increase of 200; bills receivable a decrease of 3,000; bills payable at decrease of 4,000; and outstanding expenses a decrease of 2,000. Ascertain cash flow from operating activities.
[Ans.: Net cash flow from operating activities: 1,54,800]
3. X Ltd. made a profit of 1,20,000 after charging depreciation of ? 20,000 on assets and a transfer to general reserve of 30,000. The goodwill written off was 7,000 and the gain on sale of the machineries was 3,000. Changes in the value of current assets and liabilities at the end of the year:
Debtors showed an increase of 6,000; creditors an increase of 10,000; prepaid expenses an increase of 200; bills receivable a decrease of 3,000; bills payable a decrease of 4,000 and outstanding expenses a decrease of 2,000.
Ascertain cash flow from operating activities.
[Ans.: Net cash from operating activities: 1,74,800]
4. On 31 March 2011 Y Ltd. made a profit of 1,25,000 after considering the following.
Depreciation on Billings |
25,000 |
Depreciation on Plant and |
45,000 |
Machinery |
|
Amortization or Goodwill |
20,000 |
Gain on Sale of Machinery |
10,000 |
The Current Assets and Current Liabilities:
|
1.4.2010 |
31.3.2011 |
Accounts Receivable |
35,000 |
45,000 |
Stock on Hand |
75,000 |
69,000 |
Cash on Hand |
18,000 |
30,000 |
Accounts Payable |
30,000 |
32,000 |
Expenses Payable |
10,000 |
5,000 |
Bank Overdraft |
60,000 |
35,000 |
Ascertain Cash Flow from Operating Activities
[Ans.: Net cash flow from operating activities: 1,98,000]
5. Calculate net cash flows from operating activities from the following details.
Profits Earned During the Year 2011 |
50,000 |
Transfer to General Reserve |
10,000 |
Depreciation Provided |
20,000 |
Profit on Sale of Furniture |
5,000 |
Loss on Sale of Machineries |
10,000 |
Preliminary Expenses Retain off |
10,000 |
Particulars | 2010 | 2011 |
---|---|---|
Accounts Receivable |
35,000 |
45,000 |
Debtors |
10,000 |
15,000 |
Bills Receivable |
7,000 |
5,000 |
Stock |
15,000 |
18,000 |
Prepaid Expenses |
2,000 |
3,000 |
Bills Expenses |
15,000 |
25,000 |
Creditors |
20,000 |
18,000 |
Outstanding Expenses |
3,000 |
4,000 |
[Ans.: Net cash from operating activities: 87,000
6. Y Ltd. made a net profit of 15,000 for the year ending on 31 March 2011 after taking the following into consideration.
Depreciation on Plant and Machinery |
15,000 |
Depreciation on Buildings |
45,000 |
Amortization of Goodwill |
20,000 |
Loss on Sale of Machinery |
5,000 |
Current assets and current liabilities at the beginning and at the end of the year
Particulars |
1.4.2010 |
31.3.2011 |
|
||
Accounts Receivables |
35,000 |
40,000 |
Stock in Hand |
55,000 |
42,000 |
Cash in Hand |
12,000 |
2,000 |
Expense Due |
6,000 |
8,000 |
Accounts Payable |
60,000 |
53,000 |
Calculate cash flow from operating activities
[Ans.: Cash flow from operating activities: 97,000]
7. The following balances appeared in machinery account and accumulated depreciation account in the books of XYZ Ltd.
|
31 March 2011 | 31.3.2011 |
---|---|---|
|
||
Machinery Account A/c |
17,78,985 |
26,55,450 |
Accumulated |
3,40,795 |
4,75,690 |
Depreciation A/c |
|
|
Additional Information:
A machinery costing 2,60,000 on which accumulated depreciation 1,00,000 was sold for 75,000. You are required to
[Ans.:
8. Calculate the cash flow from operating activities form the following information.
Profit for the Year |
50,000 |
Transfer to General Reserve |
10,000 |
Depreciation Provided |
20,000 |
Profit on Sale of Furniture |
5,000 |
Loss on Sale of Furniture |
10,000 |
Preliminary Exp. Written off |
10,000 |
Particulars |
31 March 2008 |
31 March 2009 |
|
||
Debtors |
10,000 |
15,000 |
Bills Receivable |
7,000 |
5,000 |
Stock |
15,000 |
18,000 |
Prepaid Expenses |
2,000 |
3,000 |
Creditors |
20,000 |
18,000 |
Bills Payable |
15,000 |
25,000 |
Outstanding Expenses |
3,000 |
4,000 |
[Ans.: Net cash flow from operating activities: 97,000]
9. From the following summarized balance sheets of a company, compute cash flow from operating activities.
[Ans : (i) Net profit before tax and extraordinary items:30,000
(ii) Net cash flow operating activities:3,600]
10. From the following summarized balance sheets of a company calculate cash flow from operating activities.
[Ans.: Cash flow from operating activities: 13,600]
11. From the following statement compute cash generated from operating activities. Statement of profit for the year ending on 31 March 2011.
[Ans.: Cash generated from operating activities: 55,000]
12. From the following summarized balance sheets calculate flow from operating activities.
[Ans.: Cash flow from operating activities: 10,000]
13. A company had the following balances; investment at the beginning of the period is 46,000. Investment at the end of the period is 30,000. During the year, the company sold 60% of its investment held at the beginning of the period at a profit of 10,000. Calculate the cash flow from investing activities.
[Ans.: Cash flow from investing activities: 26,000]
[Hint: Investment A/c (Bal. Fig.): 11,600]
14. From the following information calculate cash flow from investing activities.
Investment at the beginning of the period: 25,000
Investment at the end of the period: 24,000
During the year, the company sold 40% of its investments held at the beginning of the period at a profit of 9,000
[Ans.: Cash flow from investing activities: 20,000]
[Hint: Purchase value { 9,000}]
15. From the following particulars calculate cash flow from investing activities.
Purchase |
Sold |
|
---|---|---|
Investment |
2,30,000 |
1,40,000 |
Goodwill |
1,75,000 |
— |
Machinery |
5,30,000 |
2,10,000 |
Patents |
— |
75,000 |
Interest received on debentures held as an investment 18,000. Dividend received on shares held as investments 25,000. A part of the building was purchased out of surplus funds for investment purposes, which earned 75,000 by way of rent.
[Ans.: Net cash used in investing activities: 3,92,000]
16. From the following information calculate cash flow from investing activities.
31 March 2010 |
31 March 2011 |
|
---|---|---|
Machinery |
5,00,000 |
1,00,000 |
Accumulated |
1,00,000 |
1,20,000 |
Depreciation |
|
|
Patent Rights |
3,00,000 |
1,80,000 |
Additional Information:
[Ans.: Net cash flow from investing activities: 40,000]
[Hint: Balancing figures: machinery A/c is 1,00,000, accumulated depreciation A/c is 50,000 and patents account is 1,15,000]
17. Ajay & Co. has plant and machinery, whose written down value on 1 April 2008 was 7,50,000 and on 31 March 2009 was 9,00,000. Depreciation for the year was 30,000. At the beginning of the year, a part of the plant was sold for 20,000, which had a written down value of 16,000.
[Ans.: Net cash flow from investing activities: 1,76,000]
[Hint: Plant & machinery A/c Bal. Fig.: 1,96,000]
18. Calculate cash flow from financial activities from the following information.
31 March 2010 |
31 March 2010 |
|
---|---|---|
Equity Share Capital |
6,00,000 |
8,00,000 |
9% Debentures |
2,00,000 |
1,00,000 |
Securities Premium |
50,000 |
75,000 |
Additional Information:
Interest paid on debentures is 18,000.
[Ans.: Net cash from financing activities: 1,07,000]
19. A public limited company provides the following figures. Calculate the net cash flow from financing activities.
31 March 2010 |
31 March 2010 |
|
---|---|---|
Equity Share Capital |
8,00,000 |
12,00,000 |
10% Debentures |
1,50,000 |
— |
6% Debentures |
— |
3,00,000 |
Additional Information:
[Ans.: Net cash flow financing activities: 95,000]
20. Calculate cash flow from (i) investing activities and (ii) financing activities from the following information.
31 March 2010 |
31 March 2010 |
|
---|---|---|
Furniture (at Cost) |
30,000 |
40,000 |
Accumulated |
7,000 |
10,000 |
Depreciations |
|
|
Furniture |
|
|
Capital |
1,50,000 |
2,25,000 |
Loan from Bank |
40,000 |
25,000 |
During the year 2010–11, furniture costing 5,000 was sold at a profit of 3,000. Depreciation charged during the year was 6,000.
[Ans.
[Hint: Sale price: 5,000; Furniture purchased: 15,000; Accumulated depreciation: 3,000]
21. From the following summary cash account of XYZ Ltd. you are required to prepare a cash flow statement for the year ended on 31 March 2011 in accordance with AS-3.
Summary Cash Account for the Year Ended on 31 March 2011
[Ans.:
22. The balance sheet of J.K. Ltd. as on 31 March 2010 and 31 March 2011 are as follows:
Additional Information:
An old machine was sold for 20,000, which had a written down value of 10,000; dividend paid during the year was 16,000 and depreciation charged to profit and loss account for the year amounted to 10,000. Prepare the cash flow statement.
[Ans.:
23. X Ltd. gives you the following information for the year ended on 31 March 2011:
You are required to prepare cash flow statement using indirect method.
[B.Com (Hons)—Delhi 2007, Modified]
[Ans.: Net cash from operating activities: 4,92,000
Net cash used in investing activities: (5,13,750)
Net cash from financing activities: 1,21,500]
24. The following data were provided by the accounting records of X Ltd. as the year ended on 31 March 2011:
|
|
Sales |
40,00,000 |
Cost of Goods Sold |
(24,00,000) |
Gross Profit |
16,00,000 |
Operating Expenses |
(2,00,000) |
(Including Depreciation) |
|
Indirect Expenses Paid |
(1,20,000) |
Interest Income Received |
40,000 |
Gain on Sale of Investments |
60,000 |
Loss on Sale of Plant |
(20,000) |
Net Profit Before Tax |
7,60,000 |
Provision for Income Tax |
(2,80,000) |
Net Profit After Tax |
4,80,000 |
Assets | As on 31 March 2011 | As on 31 March 2010 |
---|---|---|
Plant |
28,00,000 |
20,00,000 |
Less: Accumulated Depreciation |
(4,00,000) |
(3,20,000) |
|
24,00,000 |
16,80,000 |
Investment (Long-term) |
4,00,000 |
6,40,000 |
Inventory |
6,00,000 |
4,40,000 |
Accounts Receivable |
1,80,000 |
2,20,000 |
Cash at Bank |
2,00,000 |
1,80,000 |
|
37,80,000 |
31,60,000 |
Liabilities |
||
Equity Share Capital |
16,00,000 |
8,00,000 |
Securities Premium |
80,000 |
- |
General Reserve |
6,00,000 |
5,20,000 |
P & L A/c |
1,40,000 |
32,000 |
Debentures |
10,00,000 |
14,00,000 |
Accounts Payable |
2,40,000 |
2,08,000 |
Provision for Tax |
1,20,000 |
2,00,000 |
|
37,80,000 |
31,60,000 |
Additional Information:
You are required to prepare cash flow statement as per AS-3 (Revised)
[B.Com (Hons)—Delhi 2008, Modified]
[Ans : Net cash from operating activities:
4,40,000
Net cash used in investing activities: (4,88,000)
Net cash from financing activities: 68,000 Net increase in cash and cash equivalents: 20,000]
25. The data given ahead were provided by the accounting records of Shuchi diamonds Ltd.:
(for the Year Ended on 31 March 2010)
|
|
|
Sales |
|
3,49,000 |
Cost of Goods Sold |
|
(2,60,000) |
Gross Margin |
|
89,000 |
Operating Expenses |
|
(73,500) |
(Including Depreciation Expenses of 18,500) |
|
15,500 |
Other Income (Expenses): |
|
|
Interest Expenses Paid |
(11,500) |
|
Interest Income Received |
3,000 |
|
Gain on Sale of Investments |
6,000 |
|
Loss on Sale of Plant |
(1,500) |
(4,000) |
Provision Before Tax |
|
11,500 |
Provision for tax |
|
(3,500) |
Provision After Tax |
|
8,000 |
Comparative Balance Sheets (as on 31 March)
Analysis of selected transactions and accounts during 2010–11:
Prepare cash flow statement for the year ended on 31 March 2011 as per AS-(3) (Revised) using indirect method.
[B.Com (Hons)—Delhi 2009, Modified]
[Ans: Net cash from operating activities: 23,500
Net cash used in investing activities: (42,500)
Net cash from financing activities: 34,500]
26. From the information given below relating to Pooja Ltd., you are required to prepare a cash flow statement:
Assets | 31 March 2011 | 31 March 2010 |
---|---|---|
Freehold Land and Building |
50,000 |
— |
at Cost |
|
|
Less: Depreciation |
(10,000) |
— |
Leasehold Land and Building |
— |
25,000 |
Less: Depreciation |
— |
(500) |
Plant and Equipment at Cost |
1,50,000 |
6,00,000 |
Less: Depreciation |
(1,25,000) |
(1,60,000) |
Investment at Cost |
30,000 |
— |
Stock in Hand |
1,50,000 |
1,00,000 |
Debtors |
50,000 |
50,000 |
Bank |
5,000 |
— |
Discount on Issue of |
— |
1,250 |
Debentures |
|
|
|
3,00,000 |
6,15,750 |
Liabilities and Capital |
||
Preference Shares of 10 |
— |
25,000 |
Ordinary Shares of 10 |
1,00,000 |
1,60,000 |
Capital Redemption Reserve |
20,000 |
— |
Account |
|
|
Securities Premium Account |
10,000 |
20,000 |
Surplus on Sale of: |
|
|
Freehold Land and Building |
— |
60,000 |
Investment |
— |
10,000 |
Govt. Grants |
15,000 |
25,000 |
Retained Profits |
1,05,000 |
1,25,000 |
Debentures |
— |
50,000 |
Loan from UTI for 5 years |
— |
25,000 |
Creditors for Goods |
20,000 |
35,000 |
Bank Overdraft |
— |
47,000 |
Taxation |
30,000 |
30,000 |
Acceptance Credit |
— |
3,750 |
3,00,000 |
6,15,750 |
Additional information:
[B.com (Hons)—Delhi 2009, Modified]
[Ans: Net cash from operating activities: 1,28,000
Net cash used in investing activities: (3,35,000)
Net cash from financing activities: 2,02,000)]
27. The following are the balance sheets of Subhikishu Ltd. as on 31 March 2010 and 31 March 2011, respectively.
Additional Information:
Prepare cash flow statement as per AS-3 (Revised). Show all working clearly.
[B.Com (Hons)—Delhi 2010, Modified]
[Ans : Cash from operating activities: 6,85,000
Cash used in investing activities: (2,66,250)
Cash used in financing activities: (3,31,250)]
28. From the following details relating to the account of Grow More Ltd. prepare cash flow statement:
31 March 2011 | 31 March 2010 | |
---|---|---|
Assets: |
|
|
Plant and Machinery |
14,00,000 |
10,00,000 |
Land and Building |
12,00,000 |
8,00,000 |
Investments |
2,00,000 |
— |
Sundry Debtors |
10,00,000 |
14,00,000 |
Stock |
8,00,000 |
4,00,000 |
Cash on Hand/Bank |
4,00,000 |
4,00,000 |
|
50,00,000 |
40,00,000 |
Liabilities: |
|
|
Share Capital |
20,00,000 |
16,00,000 |
Reserve |
4,00,000 |
3,00,000 |
P & L A/c |
2,00,000 |
1,20,000 |
Debentures |
4,00,000 |
— |
Provision for Taxation |
2,00,000 |
1,40,000 |
Proposed Dividend |
4,00,000 |
2,00,000 |
Sundry Creditors |
14,00,000 |
16,40,000 |
|
50,00,000 |
40,00,000 |
Prepare cash flow statement.
[C.A. (Final)—November 2005, Modified]
[Ans: Net cash from operating activities: 6,20,000
Net cash used in investing activities: (12,20,000)
Net cash from financing activities: 6,00,000]
29. From the summary cash account of X Ltd. prepare a cash flow statement for the year ended on 31 March 2011 in accordance with AS-3 (Revised) using direct and indirect methods. The company does not have any equivalents:
[C.A. (Final)—Modified]
[Ans: Net cash from operating activities: 15,00,000
Net cash used in investing activities (6,00,000)
Net cash from financing activities: (3,00,000)
[NOTE: Answers will be the same under both the methods.]
30 The balance sheet of New Light Ltd. for the years ended on 31 March 2010 and 2011 are as follows:
Additional Information:
Prepare cash flow statement as per revised accounting standard-3 by indirect method.
[C.A. (Final) 2003—Modified]
[Ans: Net cash from operating activities: 11,84,000
Net cash used in investing activities:
(12,72,000)
Net cash from financing activities: (88,000)]
31. XYZ Ltd. gives you the following information. You are required to prepare a cash flow statement by using indirect methods as per AS-3 for the year ended on 31 March 2011:
Additional Information:
[C.A. (Final)—2004, Modified]
[Ans: Net cash from operating activities: 9,80,000
Net cash used in investing activities: (6,70,000)
Net cash used in financing activities: (nil)]
32. Nee Ltd. had the following figures as on 1 April 2010:
|
|
Fixed Assets—Cost |
18,00,000 |
Less: Depreciation |
6,30,000 |
|
11,70,000 |
Bank Balance |
1,05,000 |
Current Assets, |
7,50,000 |
other than Bank Balance |
|
Current Liabilities |
3,00,000 |
Capital (Shares of 10 Each) |
12,00,000 |
The company made the following estimates:
At the end of the accounting year, the company sends all the cash in hand to the bank.
Prepare a cash flow statement for the year ended on 31 March 2011 and estimate the bank balance or overdraft as on that date.
[Ans: Net cash from operating activities: 2,94,000
Net cash used in investing activities: (2,40,000)
Net cash from financing activities: 1,33,200
Bank balance as on 31 March 2011: 25,800