UNIT IV
Cash Flow Analysis
Cash Flow: Overview
There are generally four types of financial statements in accounting: the balance sheet, the income statement, the cash flow statement, and the cash flow statement. Let's take a closer look at the last two.
In financial accounting, a cash flow statement refers to the change in a company's cash and equivalents from one period to the next. However, the flow of money has two different implications. One is for accounting purposes and the other is for investment purposes.
Cash flow
Cash flows are recorded on the company's cash flow statement. This statement (one of the company's key statements) shows the actual inflows and outflows of cash (or cash-like assets) from its investment activities. This is a mandatory report under generally accepted accounting principles (GAAP)
This is different from the income statement, which records data and transactions that may not be fully realized, such as uncollected income and unpaid income. On the other hand, this information is already entered in the cash flow statement, which gives you a more accurate picture of how much cash your company is generating.
The cash flow statement allows you to classify cash flow sources into three different categories:
- Cash Flow from Operating Activities: Cash generated from the general or core business of the business is listed in this category.
- Cash Flows from Investing Activities: This section describes the cash flows spent on investments such as new equipment.
- Cash Flows from Financing Activities: This category includes all transactions involving the debtor, such as income from new debt and dividends paid to investors.
Specimen of Cash Flow
Cash flow statement for XYZ business
For the year ended 31st December 2020
CASH FLOW FROM OPERATING ACTIVITIES
Cash receipts from customer
Cash paid to supplier
Cash paid to employees
Cash paid for other operating expenses
Cash generated from operations
Dividend received *
Interest received
Interest paid
Tax paid
Net cash flow from operating activities
CASH FLOW FROM INVESTING ACTIVITIES
Proceeds from capital contributed
Proceeds from loan
Payment of loan
Net cash flow from financing activities
CASH FLOW FROM FINANCING ACTIVITIES
Proceeds from capital contributed
Proceeds from loan
Payment of loan
Net cash flow from financing activities
NET INCREASE /DECREASE IN CASH
Cash at the beginning of the period
Cash at the end of period
A company receives an inflow of cash income from selling goods, providing services, selling assets, earning interest on investments, renting, acquiring loans, or issuing new shares. Cash outflows can result from purchases, loan repayments, business expansions, payroll payments, or dividend distributions.
Investors and lenders have liquidity and cash on hand because the Securities and Exchange Commission (SEC) requires all listed companies to use accrual accounting and largely ignores the actual balance of cash on hand. It relies on cash flow statements to evaluate flow management. It's a more reliable tool than the metrics companies use to dress up their earnings, such as interest, taxes, depreciation, and earned before interest (EBITDA)
Cash flow as per accounting standards:
- Applicability of AS3 income Statement
The applicability of the income statement is defined under the businesses Act 2013. As defined by the law, financial statements include:
I. Record
Ii. Profit and Loss Account / Balance Account
Iii. Income statement
Iv. Statement of changes in shareholders' equity, etc.
v. Annotation
Therefore, the income statement must be prepared by all companies, but the law also specifies certain categories of companies that are exempt from an equivalent.
For eg: One Person Company (OPC), Small Company, and Dormant Company.
- OPC means a corporation with just one member.
- SMEs are private companies with a maximum paid-up capital of Rupees. The utmost sales are 500,000 rupees. 2 rolls.
- A dormant company is an inactive company that's established for future projects or simply to carry assets and has no significant transactions.
2. Cash and cash equivalents
Cash equivalents are held by a corporation to satisfy its short-term cash commitment on behalf of an investment or other such purpose. For investments that qualify as cash equivalents:
1. The investment must be easily convertible to cash
2. Must be exposed to a really low level of risk regarding changes in its value
Therefore, an investment is taken into account a debt instrument as long as such investment features a short maturity within 3 months from the date of acquisition.
The AS 3 income statement states that movements between items that form a part of cash or cash equivalents should be excluded because they are part of a company's cash management, not business, financing, and investment activities. Cash management consists of investing surplus take advantage cash equivalents.
3. View income
The income statement must represent the cash flows within the amount during which they're categorized as follows:
A. Sales activities
B. Investment
C. Financing activities
Companies got to prepare and present cash flows from operations, financing, and investment activities during a way that suits their business.
Grouping activities provides information that permits users to assess the impact of such activities on the company's overall financial position and to assess the worth of money and cash equivalents.
A. Sales activities
Cash flow from operating activities comes primarily from activities that generate the company's main revenue. For example:
- Cash received from the sale of products and services
- Cash received in fees, royalties, commissions, and various other sorts of revenue
- Cash paid to suppliers of products and services
B. Investment activities
Cash flows from investing activities represent outflows for cash flows and resources aimed toward generating future income. For example:
- Cash purchased the acquisition of fixed assets
- Cash received from the disposal of fixed assets (including intangible assets)
- Cash paid to accumulate shares, warrants or debt certificates of other companies and equity interests in joint ventures
C. Financing activities
Financing activities are activities that change the composition and size of the owner's capital and therefore the company's debt. For example:
- Cash received from the issuance of shares or other similar securities
- Cash received from the issuance of loans, corporate bonds, bonds, bills, and other short-term or long-term debt
- Repayment of debt
4. Income from operating activities
Companies should report cash flows from operating activities using:
1. Direct method-if all major classes of money receipt and payment are presented. Or
2. Indirect method – If net or loss is adjusted as follows:
a) Impact of non-cash transactions like depreciation, deferred taxes and provisions.
b) Income or deferral of future or past operating cash income or payments
c) Expenses or income related to income financing or investment
5. Income from investment and financing activities
An entity must separately record all major classes of money receipts and payments resulting from financial and investment activities, except people who got to be reported on a net basis.
- Net-based income
Cash flows from any of the subsequent operating, financing or investing activities could also be reported in net form.
- Cash income and payments on behalf of the client if the cash flows reflect the activities of such clients instead of the activities of the corporate itself.
- Revenue and cash payments for products with large amounts, fast sales and short maturities
Cash flows from each of the subsequent activities of a financial company could also be reported in net form.
- Cash income and payments for receipt and repayment of fixed-maturity deposits
- Placement and withdrawal of deposits from other financial companies
- Loans and cash advance payments are provided to Customer / Customer and repayment of such loans and advance payments.
B. Foreign currency cash flow
Cash flows from transactions in foreign currencies should be recorded in the company's reporting currency using the following methods:
Foreign currency amount * FX rates the exchange rate between the cash flow date report and the foreign currency.
If the result is similar to using the cash flow date rate, you can use a rate that is close to the actual rate.
The impact of exchange rate fluctuations on cash and cash equivalents held in foreign currencies must be reported as a separate and separate part of the adjustment of changes in cash and cash equivalents during the period.
6. Special items, dividends and profits
Cash flows related to special items should be categorized as originating from operating, financing, or investing activities, as appropriate and clearly disclosed.
Cash flows from receiving and paying dividends and interest must be disclosed separately. For financial companies, cash flows from receiving and paying dividends and interest should be categorized as cash flows from operating activities.
For other companies, cash flows from interest expense should be categorized as cash flows from financing activities, while dividends and interest received should be categorized as cash flows from investing activities.
7. Tax on income
Income tax cash flows must be disclosed separately and reported as cash flows from operating activities unless they may be explicitly related to investment and financing activities.
8. Acquisition and disposal of business divisions including subsidiaries
Total cash flows from acquisitions and disposals of business units, including subsidiaries, must be viewed as investment activity and reported separately.
An entity must provide a complete of the subsequent for both acquisitions and disposals of other business units, including subsidiaries, within the subsequent period:
(A) Total purchase or disposal
(B) Purchase or disposal price discharged as cash and cash equivalents
9. Non-cash transaction
Financing and investment transactions that do not require cash or cash equivalents should not be included in the cash flow statement. These transactions must be presented elsewhere in the financial statements in a way that provides relevant information regarding such financing and investment activities.
10. Disclosure
An entity must disclose the amount of substantial unusable cash and cash equivalents it holds, along with management commentary.
Commitments that may result from discounted bills of exchange and other similar obligations undertaken by an entity are usually disclosed in the financial statements by note, even if the likelihood of loss is low.
Specimen of Cash Flow Statement:
Main differences between AS3 and IndAS7
Details
| AS3 Cash Flow Statement
| Ind AS7 Cash Flow Statement |
Bank Overdrafts
| AS3 does not have such a requirement
| Ind AS 7 explicitly includes bank overdraft as a part of cash and cash equivalents to be repaid for the asking |
Cash Flows from Extracurricular Activities.
| AS3 requires that cash flows related to extracurricular activities be classified as cash flows from operating activities, financing activities, and investing activities. | IndAS7 does not include such a requirement |
Changes in ownership of subsidiary | There are no such requirements for cash flows from changes in ownership of subsidiary AS3
| Ind AS 7 requires a classification of cash flows resulting from changes in ownership of subsidiaries. This will not lose your control as cash. Flow from financial activities |
Accounting for investments in subsidiaries or affiliates .
| AS 3 does not have such a requirement | Ind AS 7 requires the use of the cost method or equity method when accounting for investments in subsidiaries or affiliates |
Disclosure Requirements | AS3 requires less disclosure requirements compared to Ind AS 7. | Ind AS 7 requires more disclosure requirements.
|
Here may be a compilation of the problems with income statements alongside relevant solutions.
Problem 1:
From the overview of the Cash Account of x INC., we have finished using the 31st March2007 direct method of preparing the cash flow statement of the year according to AS-3. We have no cash equivalents.
Summary (cash account ) 31.3.2007
| Rs |
| Rs |
To balance b/d 1.4.2006 | 50 | By payment to supplier | 2,000 |
To equity shares | 300 | By purchase of fixed asset | 200 |
To receipt from customer | 2,800 | By overheard expenses | 200 |
To sale of fixed asset | 100 | By wages & salaries | 100 |
|
| By taxation | 250 |
|
| By dividend | 50 |
|
| By repayment of loan | 300 |
|
| By balance c/d | 150 |
| 3,250 |
| 3,250 |
Solution :
Cash flow statement
For the year ended 31st march 2007
(A) Cash flow from operating activities |
|
|
Cash from customer | 2800 |
|
Cash payment to suppliers | (2,000) |
|
Cash paid for overhead expenses | (200) |
|
Cash paid for salaries | (100) |
|
Cash generated from operations | 500 |
|
Income tax paid | (250) |
|
Net cash from operating activities |
| 250 |
(B) Cash flows from investing activities |
|
|
Purchase of fixed assets | (200) |
|
Cash from sale of fixed assets | 100 |
|
Net cash used in investing activities |
| (100) |
© cash flow from financing activities |
|
|
Issue of equity shares | 300 |
|
Repayment of loan | (300) |
|
Payment of dividends | (50) |
|
Net cash used in financing activities |
| (50) |
Net increase in cash & cash equivalent |
| 100 |
Cash and cash equivalent (1.4.06) |
| 50 |
Cash and cash equivalent (31.3 .07) |
| 150 |
Problem 2:
Create a cash flow statement for Suryan Corporation. From: additional information:
Balance sheet
Liabilities | 1.1.06 Rs | 31.12.06 Rs | Assets | 1.1.06 Rs | 31.12.06 Rs |
Share capital | 1,00,000 | 4,00,000 | Goodwill | - | 20,000 |
8% debenture | - | 2,00,000 | Machinery | 1,25,000 | 4,75,000 |
Retained earnings | 60,000 | 90,000 | Stock | 20,000 | 80,000 |
Creditors | 40,000 | 1,00,000 | Debtor | 30,000 | 1,00,000 |
Bills payable | 20,000 | 40,000 | Cash at bank | 50,000 | 1,50,000 |
Provision for tax | 30,000 | 40,000 | Cash in hand | 25,000 | 45,000 |
| 2,50,000 | 8,70,000 |
| 2,50,000 | 8,70,000 |
Other information:
(a) During 2006, the sole trader's business was purchased by issuing shares of Rs. 2, 00,000. The assets acquired from him were: goodwill Rs. 20,000, machine Rs. 1, 00,000, 50,000 and debtors Rs. 30,000.
(b) The provision for the tax imposed in 2006 was Rs. 35,000.
(c) Corporate bonds were issued at a 5% premium included in retained earnings.
(d) The depreciation levied on the machine was Rs. 30,000.
Cash flow statement of suryan Ltd.,
For the year 2006
Particular | Rs | Rs |
|
|
|
Profit before tax and extraordinary items | 55,000 |
|
Adjustment for: |
|
|
Depreciation on machinery | 30,000 |
|
Operating profit before working capital changes | 85,000 |
|
Increase in creditors ( 1,00,000-40,000) | 60,000 |
|
Increase in bills payable (40,000-20,000) | 20,000 |
|
Increase in stock (excluding stock bought by issue of shares) (80,000-50,000-20,000) | (10,000) |
|
Increase in debtors (excluding debtors acquired by issue of shares) (1,00,000-30,000-30,000) | (40,000) |
|
Cash outflow from operations | 1,15,000 |
|
Income tax paid |
| |
Net cash from operating activities |
| 90,000 |
II. Cash flow from investing activities |
|
|
Machinery purchased for cash |
| |
|
| 2,80,000 |
III. Cash flow from financing activities : |
|
|
Cash proceeds from issue of shares |
| |
Cash proceeds from issue of debenture |
| |
Net cash flow from financing activities |
| |
Net increase in cash and cash equivalets |
| 1,20,000 |
Add: cash and cash equivalent at the beginning of the year |
| 75,000 |
Cash and cash equivalent at the end of the year |
| 1,95,000 |
Working:-
| Rs |
Closing retained earning | 90,000 |
Less: opening retained earning | 60,000 |
| 30,000 |
Add: provision made for tax | 35,000 |
| 65,000 |
Less: premium on issue of debenture ( 2,00,000*5%) | 10,000 |
Net profit before tax and extraordinary items | 55,000 |
2. Provision for tax account
| Rs |
| Rs |
To bank ( tax paid) (balancing figure) | 25,000 | By balance b/d | 30,000 |
To balance c/d | 40,000 | By profit & loss (provision) | 35,000 |
| 65,000 |
| 65,000 |
3. Machinery account
| Rs |
| Rs |
To balance b/d | 1,25,000 | By depreciation | 30,000 |
To bank (purchase ) (balancing fig.) | 2,80,000 | By balance c/d | 4,75,000 |
To vendor (business purchase) | 1,00,000 |
|
|
| 5,05,000 |
| 5,05,000 |
4. Share capital account
| Rs |
| Rs |
To balance c/d | 4,00,000 | By balance b/d | 1,00,000 |
|
| By vendor A/c (business purchase) | 2,00,000 |
|
| By bank (issue for cash) | 1,00,000 |
| 4,00,000 |
| 4,00,000 |
5.
Debenture issue (face value) | 2,00,0,00 |
Add: premium on issue at 5% | 10,000 |
Total proceeds | 2,10,000 |
Problem 3:
Make-out cash flow statement from the following balance sheet of Executive Corporation:
Liabilities | 2003 Rs | 2004 Rs | Assets | 2003 Rs | 2004 Rs |
Equity share capital | 3,00,000 | 4,00,000 | Goodwill | 1,15,000 | 90,000 |
8% redeemable preference share capital | 1,50,000 | 1,00,000 | Land & building | 2,00,000 | 1,70,000 |
General reserve | 40,000 | 70,000 | Plant | 80,000 | 2,00,000 |
Profit & loss | 30,000 | 48,000 | Debtors | 1,60,000 | 2,00,000 |
Proposed dividend | 42,000 | 50,000 | Stock | 77,000 | 1,09,000 |
Creditors | 55,000 | 83,000 | Bills receivable | 20,000 | 30,000 |
Bills payable | 20,000 | 16,000 | Cash in hand | 15,000 | 10,000 |
Provision for taxation | 40,000 | 50,000 | Cash at bank | 10,000 | 8,000 |
| 6,77,000 | 8,17,000 |
| 6,77,000 | 8,17,000 |
Other information:
(A) Depreciation of Rs. 10,000 and Rs. 20,000 were filled with plants and land and buildings in 2004.
(B) Interim dividend of Rs. 20,000 has been paid in 2004.
(C) Rs. 35,000 income tax paid between 2004
Solution :
Cash flow statement
For the year ended 31st December 2004
| Rs | Rs |
(A) Cash flow from operating activities |
|
|
Net profit before tax and extraordinary item | 1,88,000 |
|
Adjustment for depreciation | 30,000 |
|
Profit from trading operations | 2,18,000 |
|
Increase in creditors | 28,000 |
|
Increase in debtors | (40,000) |
|
Increase in stock | (32,000) |
|
Increase in B/R | (10,000) |
|
Decrease in B/P | (4,000) |
|
Payment of tax | (35,000) |
|
Net cash provided from financial activities |
| 1,25,000 |
|
|
|
(B) Cash flow from investing activities |
|
|
Sale of land & building | 10,000 |
|
Purchase of plant | (1,30,000) |
|
Net cash used in investing activities |
| 1,20,000 |
© Cash flow from financial activities |
|
|
Issue of share capital | 1,00,000 |
|
Redemption of pref. Shares | (50,000) |
|
Payment of interim dividend | (20,000) |
|
Payment of dividend | (42,000) |
|
|
| (12,000) |
Net decrease in cash and cash equivalent |
| (7,000) |
Cash and cash equivalent as on 31. 3 . 2003 |
| 25,000 |
Cash and cash equivalent as on 31.3.2004 |
| 18,000 |
- Plant account
| Rs |
| Rs |
To balance b/d | 80,000 | By P&L account (Dep.) | 10,000 |
To bank ( purchase of plant ) | 1,30,000 | By balance c/d | 2,00,000 |
| 2,10,000 |
| 2,10,000 |
2. Land and building account
| Rs |
| Rs |
To balance b/d | 2,00,000 | By P&L. Account (Dep) | 20,000 |
|
| By bank (sale of land and building ) | 10,000 |
|
| By balance c/d | 1,70,000 |
| 2,00,000 |
| 2,00,000 |
3. Adjusted profit and loss account
| Rs |
| Rs |
To general reserve | 30,000 | By balance b/d | 30,000 |
To interim dividend | 20,000 | By profit before tax and extraordinary item | 1,88,000 |
To provision for taxation | 45,000 |
|
|
To goodwill | 25,000 |
|
|
To proposed dividend | 50,000 |
|
|
To balance c/d | 48,000 |
|
|
| 2,18,000 |
| 2,18,000 |
4. Proposed dividend account
| Rs |
| Rs |
To bank | 42,000 | By balance b/d | 42,000 |
To balance b/d | 50,000 | By profit and loss | 50,000 |
| 92,000 |
| 92,000 |
5. Provision for taxation account
| Rs |
| Rs |
To bank | 35,000 | By bank b/d | 40,000 |
To balance c/d | 50,000 | By profit &loss account | 45,000 |
| 85,000 |
| 85,00 |
Problem 4:
The bank statement of the business company has increased during the last financial year by Rs.1, 50,000. In the same period it issued shares of Rs. Redeemed bonds of 2, 00,000 and Rs.1, 50,000. It purchased fixed assets for Rs. Charge depreciation of 40,000 and Rs.20, 000. The working capital of the company, other than the bank balance, was increased by Rs. Calculates the company's profit during the year of 1,15,000 transactions.
Solution:
1, 50,000=profit+ 2, 00,000 – 1, 50,000 – 40,000 + 20,000 – 1,15,000
Profit=Rs.2, 35,000
Problem 5:
The chemical company has a turnover of Rs. Cash costs of 50 lakh, Rs (including taxes).Depreciation of 35lakhs and rs.5 if the lax debtor is reduced over the period by Rs.6lakhs, what is the cash from the operation?
Solution:
Cash from Operation = Rs.50 lakh-Rs 35 lakhs+Rs.6 Lakh = rupees.21 lax
There are two ways to convert net income from operating activities into net cash flow:
- Direct method, and
- Indirect methods.
Problem 6:
The following information is available from the Exclusive Ltd books. For the year ended 31st March, 2016:
(a) This year's cash turnover was Rs.10, 00,000 and account Rs turnover.12, 00,000.
(b) Accounts payable payments for inventory totaled Rs.7, 80,000.
(c) The collection for accounts receivable was Rs.7, 60,000.
(d) The rent is paid in cash Rs.2, 20,000, excellent rent that has been rs.20, 000.
(e) 4, 00,000 shares of Rs.10 face value were issued for Rs.48, 00,000.
(f) The equipment was purchased for cash Rs.16, 80,000.
(g) Dividends equivalent to Rs.10, 00,000 were declared but still not paid.
(h) Rs.4, 00,000 of the dividends declared the previous year were paid.
(i) Equipment whose book value is Rs. It sold for 1, 60,000 rupees.2, 40,000.
(j) Cash accounts increased by Rs.37, 20,000.
Prepare an income statement using the direct method.
Cash flow statement of exclusive limited for the year ended 31st march , 2016 (direct method)
Cash flows from operating activities |
|
|
Cash receipts from customer (10,00,000+7,60,000) | 17,60,000 |
|
Cash paid to suppliers and for rent | (10,00,000) |
|
Net cash flows from operating activities |
| 7,60,000 |
Cash flows from investing activities |
|
|
Sale of equipment | 2,40,000 |
|
Purchase of equipment | (16,80,000) |
|
Net cash used in investing activities |
| (14,40,000) |
Cash flow from financing activities |
|
|
Issue of equity shares ( including premium) | 48,00,000 |
|
Dividend paid | (4,00,000) |
|
Net cash flows from financing activities (B) |
| 44,00,000 |
Net increase in cash and cash equivalents (A)+(B)+(C) |
| 37,20,000 |
Problem 7:
Maduri Co., Ltd. Gives you the following information for the year that ended 31st March, 2016:
- Annual sales totaled Rs.96, 00,000. The company sells goods for cash only.
- The cost of the goods sold was 60% of sales.
- Closed stocks were higher than closed stocks by Rs.43, 000.
- Trade on 31st March, 2016 surpassed those on 31st March, 2015 by Rs.23,000.
- The taxes paid amounted to Rs.7, 00,000.
- The depreciation of fixed assets in that year was Rs. For 3, 15,000 rupees, the other costs totaled Rs.21,45,000. Unpaid costs for the 31st March, 2015 and 31st March, 2016 totaled Rs.82,000 yen each,91,000
- New machine and furniture costing Rs.10,27,500 yen
- The issue of Rights was made from 50,000 shares of Rs.10 each at a premium of Rs. Received 3 whole monies per share.
- Dividends to sum Rs. 4, 00,000 were distributed among shareholders.
- Cash at hand and in the bank as of 31st March, 2015 totaled Rs.2,13,800.
You are required to organize a income statement using the direct method.
Solution
Calculation of cash paid to suppliers and employees
Cost of sales (60% of Rs 96,00,000) |
| 57,60,000 |
Add: expenses incurred |
| 21,45,000 |
Outstanding expenses on 31st march , 2015 |
| 82,000 |
Excess of closing inventory |
| 43,000 |
|
| 80,30,000 |
Less: excess of closing creditors over opening creditors | 23,000 |
|
Outstanding expenses on 31st march , 2016 | 91,000 | 1,14,000 |
|
| 79,16,000 |
Income from issuance of share capital:
Issue price of one share=Rs. 10 + Rs.3 = Rs.13
Income from the issuance of 50,000 shares=Rs. 13x50, 000 = Rs. 6, 50,000
Cash flow statement of Madhuri Ltd. For the year ended 31st march,2016
(A) Cash flow from operating activities |
|
|
Cash receipt from customer | 96,00,000 |
|
Cash paid to supplier and employees | (79,16,000) |
|
Cash inflow from operations | 16,84,000 |
|
Tax paid | (7,00,000) |
|
Net cash from operating activities |
| 9,84,000 |
(B) Cash flow from investing activities |
|
|
Purchase of fixed assets | (10,27,500) |
|
Net cash used in investing activities |
| (10,27,500) |
© cash flow from financing activities |
|
|
Proceeds from issue of share capital | 6,50,000 |
|
Dividend paid | (4,00,000) |
|
Net cash from financing activities |
| 2,50,000 |
Net increase in cash and cash equivalents (A+B+C) |
| 2,06,500 |
Cash and cash equivalent as on 31st march ,2015 |
| 2,13,800 |
Cash and cash equivalents as on 31st march ,2016 |
| 4,20,300 |
Problem 8:
A summary of the caching extracted from the book of happy Co., Ltd.:
You should prepare the company's cash flow statement for the period ended in accordance with Indian Accounting Standards-31st March, 2016-3 (revised).
Solution:
Cash flow statement for the period ending 31st march, 2016
(A) Cash flow from operating activities |
|
|
Receipts from customer | 11,132 |
|
Payment to suppliers | (8,188) |
|
Payment of wages and salaries | (276) |
|
Payment of overheads | (460) |
|
Payment of taxes | (972) |
|
Net cash from operating activities |
| 1,236 |
(B) Cash flow from investing activities |
|
|
Proceeds on sale of fixed assets | 512 |
|
Acquisition of (payment) fixed assets | 920 |
|
Net cash used in investing activities |
| (408) |
© cash flow from financing activities |
|
|
Proceeds in issue of shares | 1,200 |
|
Payment of dividends | (320) |
|
Repayment of bank loans | (1,000) |
|
Net cash used in financing activities |
| (120) |
Net increase in cash and cash equivalent |
| 708 |
Cash and cash equivalent at the beginning of the period |
| 140 |
Cash and cash equivalent at the end of period |
| 848 |
Problem 9:
The following information is available from the books of Standard Company Ltd.:
This is a calculated cash flow business.
Particular | 2015 | 2016 |
Profit made during the year |
| 2,50,000 |
Income received in advance | 500 | 600 |
Prepaid expenses | 1,600 | 1,400 |
Debtors | 80,000 | 95,000 |
Bills receivable | 25,000 | 20,000 |
Creditors | 45,000 | 40,000 |
Bills payable | 13,000 | 15,000 |
Outstanding expenses | 2,500 | 2,000 |
Accured income | 1,500 | 1,200 |
Solution:
Statement showing cash flow from operations
Profit made during the year |
| 2,50,000 |
Add: decrease in debtors | 15,000 |
|
Increase in creditors | 5,000 |
|
Increase in outstanding expenses | 500 | 20,500 |
|
| 2,70,500 |
Less: decrease in income received in advance | 100 |
|
Increase in prepaid expenses | 200 |
|
Increase in bills payable | 5,000 |
|
Decrease in bills payable | 2,000 |
|
Increase in accrued income | 300 | 7,600 |
Cash generated from operations |
| 2,62,900 |
Problem 10:
Swastik oils Inc. Offers the following information for the end of the year 31st March, 2016:
Profit and loss account for the year ended 31st march,2016
Particular | Rs | Particular | Rs |
To salaries | 5,000 | By gross profit | 25,000 |
To rent | 1,000 | By profit & sale of land | 5,000 |
To depreciation | 2,000 | By income tax refund | 3,000 |
To loss on sale of plant | 1,000 |
|
|
To goodwill written off | 4,000 |
|
|
To proposed dividend | 5,000 |
|
|
To provision for tax | 5,000 |
|
|
To net profit | 10,000 |
|
|
| 33,000 |
| 33,000 |
You must prepare the cash flow statement in accordance with ias-3 for the year ended 31st March, 2016.(Make assumptions if necessary).
Solution:
Statement showing cash generated from operations
Net profit |
| 10,000 |
Add: non cash item | 2,000 |
|
Depreciation | 1,000 |
|
Loss on sale of plant | 4,000 |
|
Goodwill written off | 5,000 |
|
Proposed dividend | 5,000 | 17,000 |
Provision for tax |
| 27,000 |
Less: nonoperating income |
|
|
Profit on sale of land | 5,000 |
|
Income- tax refund | 3,000 | 8,000 |
Funds from operations |
| 19,000 |
Add: decrease in current assets |
| Nil |
Increase in current liabilities |
|
|
Less: increase in current assets |
| Nil |
Decrease in current liabilities |
|
|
Cash generated from operations |
| 19,000 |
Problem 11:
The following data is from Jupiter Ltd. You can get it from the book.
Net profit | 37,500.00 |
Dividend (including interim dividend paid) | 12,000.00 |
Provision for income-tax | 7,500.00 |
Income- tax paid during the year | 6,372.00 |
Loss on sale of assets(net) | 60.00 |
Book value of assets sold | 277.50 |
Depreciation charged to profit& loss account | 30,000.00 |
Profit on sale of investment | 150.00 |
Value of investment sold | 41,647.50 |
Interest income on investment | 3,759.00 |
Interest expenses | 15,000.00 |
Interest paid during the year | 15,780.00 |
Increase in working capital (excluding cash and bank balance) | 84,112.50 |
Purchase of fixed asset | 21,840.00 |
Investment in joint venture | 5,775.00 |
Expenditure on construction work- in -progress | 69,480.00 |
Proceeds from long -term borrowings | 38,970.00 |
Proceeds from short- term borrowing | 30,862.50 |
Opening cash and bank balances | 11,032.50 |
Closing cash and bank balances | 2,569.50 |
Other information:
- Income tax liabilities for fiscal year 2014-15 were fixed at Rs.2,54,000 hence Rs refund.1,000 were received from the advance tax paid that year.
- The book value of furniture sold that year was Rs.5,000.
You need to prepare a cash flow statement for the year that ended 31st March, 2016.
Solution:
- Cash receipt from the customer:
Sales |
| 46,37,200 |
Add: debtors at the beginning | 1,87,300 |
|
Bills receivable at the beginning | 30,000 | 2,17,300 |
|
| 48,54,500 |
Less: debtors at the end | 1,84,200 |
|
Bills receivable at the end | 50,000 | 2,34,200 |
Cash receipts from customers |
| 46,20,300 |
2. cash paid to suppliers and employees;
Cost of goods sold |
| 37,21,200 |
Add: sundry operating expenses |
| 3,17,500 |
|
| 40,38,700 |
Add: stock at the end | 5,96,300 |
|
Creditors at the beginning | 2,07,200 |
|
Bills payable at the beginning | 60,000 |
|
Outstanding expenses at the beginning | 30,000 | 8,93,500 |
|
| 49,32,200 |
Less: stock at the beginning | 5,32,500 |
|
Creditors at the end | 1,57,400 |
|
Bills payable at the end | 20,000 |
|
Outstanding expenses at the end | 35,000 | 7,44,900 |
Cash paid to suppliers and employees |
| 41,87,300 |
3. tax payment:
Advance tax paid during the year | 2,70,000 |
Less: refund of previous year | 1,000 |
Total income -tax paid | 2,69,000 |
4. Purchase of land and buildings:
Cash flow statement of jupiter Ltd. For the year ended 31-3-2016 (direct method)
Cash flows from operating activities |
|
Cash receipt from customer | 46,20,300 |
Cash paid to suppliers and employees | (41,87,300) |
Cash flow from operations | 4,33,000 |
Advance income tax paid (net) | (2,69,000) |
Net cash inflow from operating activities | 1,64,000 |
Cash flow from investing activities |
|
Purchase of land and building | (1,00,000) |
Sale of furniture | 3,000 |
Net cash outflow in investing activities | 97,000 |
Cash flows from financing activities |
|
Issue of equity shares at premium | 1,30,000 |
Dividend paid (final) | (1,00,000) |
Interim dividend paid | (55,000) |
Net cash outflows in financial activities | 25,000 |
Net increase in cash and cash equivalent | 42,000 |
Cash and cash equivalent at the beginning | 1,33,400 |
Cash and cash equivalent at the end | 1,75,400 |
Cash flow satement of jupiter Ltd. For the year ended 31.3.2016
Cash flow from operating activities |
|
Net profit before tax and extraordinary items | 5,36,000 |
Adjustment for : |
|
Depreciation on land and building | 45,000 |
Depreciation on furniture ,fixture and fitting | 8,500 |
Loss on disposal of furniture | 2,000 |
Preliminary expenses amortised | 7,000 |
Operating profit before working capital changes | 5,98,500 |
Adjustment for: |
|
Increase in stock | (63,800) |
Decrease in debtors | 3,100 |
Increase in bills receivable | (20,000) |
Decrease in bills payable | (40,000) |
Decrease in creditors | (49,800) |
Increase in outstanding expenses | 500 |
Cash flow from operations | 4,33,000 |
Advance income tax paid (net) | (2,69,000) |
Net cash inflow from operating activities | 1,64,000 |
Cash flow from investing activities |
|
Purchase of land and building | (1,00,000) |
Sale of furniture | 3,000 |
Net cash outflow in investing activities | 97,000 |
Cash flows from financing activities |
|
Issue of equity shares at premium | 1,30,000 |
Dividend paid (final) | (1,00,000) |
Interim dividend paid | (55,000) |
Net cash outflows in financial activities | 25,000 |
Net increase in cash and cash equivalent | 42,000 |
Cash and cash equivalent at the beginning | 1,33,400 |
Cash and cash equivalent at the end | 1,75,400 |
References:
- Https://www.aafmindia.co.in/CashFlowStatementVsFundFlowStatementDifferenceAdvantageDisadvantageandUses
- Https://byjus.com/commerce/difference-between-cash-flow-and-fund-flow/
- Https://www.yourarticlelibrary.com/accounting/financial-statements/preparing-funds-flow-statement-steps-rules-and-format/57272
- Https://corporatefinanceinstitute.com/resources/knowledge/accounting/statement-of-cash-flows/
- Https://mca.gov.in/Ministry/pdf/INDAS7.pdf
- Https://www.indianaccounting.in/2012/02/as-3-cash-flow-statement.html
- Https://www.slideshare.net/RajaKrishnanM/ratio-classification-advantages-and-limitations
- Http://www.brainkart.com/article/Classification-of-ratios_38863/
- Http://www.iimchyderabad.com/econtent/CashFlowStatement-Problems.pdf
- Https://mycbseguide.com/blog/cash-flow-statement-class-12-accountancy-practice-questions/