Cash Flow Statement - Zeroinfy

Loading...

Cash Flow Statement IPCC Paper 1/2: Accounting/Financial Management Chapter 2-Unit 2: Cash Flow Statement

1

CA. Pankaj Goel

MCQ - Fill in the Blanks 2

MCQ: Fill In The Blanks - 1 While calculating cash from operating activities .................. are added. • • • •

Decrease in current assets Increase in debtors Decrease in current liabilities All the above.

Ans: a

3

MCQ: Fill In The Blanks - 2

Cash from operation will increase due to .......................... • • • •

a) Decrease in current assets b) Increase in current liabilities c) Neither of the two d) both (a) and (b) above

Ans: d

4

MCQ: Fill In The Blanks - 3

Inflow of cash will take due to ........................ • • • •

a) issue of shares b) Decrease in current assets c) Increase in the value of land d) Payment of tax

Ans: a

5

MCQ: Fill In The Blanks - 4

Cash from operating activities consists of ....................... • • • •

a) b) c) d)

Operational net profit Decrease in current assets increase in current liabilities all the above

Ans: d

6

MCQ – True/ False Questions 7

True/ False Questions Cash flow statement is based upon accrual basis of accounting. • False

Cash paid to employees is shown under cash flows from Operating activities. • True

Increase in the value of fixed assets will increase cash in the business. • False

Outflow of cash will take place if debentures are issued. • False 8

True/ False Questions Provision for taxes may be treated as both current and non-current liabilities • True

Cash flow statement closes by the disclosing the closing balance of cash. • True

Cash flow statement forecasts outflow of cash only. • False

Depreciation is non-cash charge. • True

9

Illustration 1 10

Problem Statement Harish Ltd. gives you the following information for the year ended 31st March, 2006: Prepare CFS as per Indirect Method 1. Sales for the year totaled Rs. 96,00,000. The company sells goods for cash only 2. Cost of goods sold was 60% of sales. 3. Closing inventory was higher than opening inventory by Rs. 43,000. Trade creditors on 31st March, 2001 exceeded those on 31st March, 2000 by Rs. 23,000. 11

Contd: 4.

PBT 1380000,Tax Paid 700000,Dep on fixed assets for the year was Rs. 3,15,000 whereas other expenses totaled Rs. 21,45,000.

5.

Outstanding expenses on 31st March, 2000 and 31st March, 2001 totaled Rs. 82,000 and Rs. 91,000 respectively.

6.

New machinery and furniture costing Rs. 10,27,500 in all were purchased.

7.

A rights issue was made of 50,000 equity shares of Rs. 10 each at a premium of Rs. 3 per share. The entire money was received with applications.

8.

Dividends and corporate dividend tax totalling Rs. 4,07,000 were paid. Cash in hand and at bank as at 31st March, 2000 totaled Rs. 2,13,800 12

Solution-1 Cash Flow Statement For the Year Ended 31 March 2006 (A) Cash Flows from Operating Activities Net profit before tax

Rs.

Rs.

13,80,000

Adjustment for: Depreciation

3,15,000

Operating profit before Working Capital changes 16,95,000 Increase in inventory Increase in trade creditors Increase in outstanding expenses Cash generated from operations Tax paid Net cash from operating activities

(43,000) 23,000 9,000 16,84,000 7,00,000 9,84,000

(  13

Contd: Cash flows from Investing Activities Purchase of fixed assets

(10,27,500)

Net cash used in investing activities

(10,27,500)

(C) Cash Flows from Financing Activities Issue of Equity Share Capital (Including premium)6,50,000 Dividends and Corporate Dividend Tax

(4,07,000)

Net cash generated from financing activities

2,43,000

Net increase in cash and cash equivalents (A + B + C)

1,99,500

Cash and cash equivalents on 31-3-2005

2,13,800

Cash and cash equivalents on 31-3-2006

4,13,300

14

Illustration 2 15

Problem Statement •From the following condensed comparative Balance Sheets of Jatin Ltd. And additional information, prepare a Cash Flow for the year 2006. Liabilities

2005 Rs.

2006 Assets Rs.

Share Capital Security Premium

70,000 80,000 Plant & Machinery 9,000 11,000 Accumulated

Retained earnings

23,820 30,820 Depreciation on

2005

2006

Rs.

Rs.

62,000 66,000

7% Mortgage loan — 20,000 plant and machinery(37,000)(26,200) Creditors 6,900 6,000 Building 95,000 1,16,000 Outstanding salaries 2,000 1,400 Accumulated Provision for taxation 1,000

1,400 depreciation on building( 43,000) (45,000) Land 10,000 12,000 Stock 10,220 9,620 Debtors 8,600 7,600 Prepaid expenses 720 800 Cash 6,180 9,800 1,12,720 1,50,620 1,12,720 1,50,620

16

Contd:  1.

2.

3. 4.

Additional information : Plant costing Rs. 16,000 (accumulated depreciation Rs. 14,800) was sold during the year for Rs. 1,200. Building was acquired during the year at a cost of Rs. 21,000. In addition to cash payment of Rs. 1,000, a 7% mortgage loan was raised for the balance. Dividend of Rs. 8,000 was paid during the year. A sum of Rs. 13,900 was transferred to provision for taxation account in 2006.(ICAI) 17

Solution-2 Cash Flow Statement For The Year Ending 31 December 2006 Rs. Rs. (A) Cash Flows from Operating Activities Net profit before tax 28,900 Adjusted for : Depreciation on : Building 2,000 Plant 4,000 6,000 Operating profit before working capital changes 34,900 Decrease in stock 600 Decrease in debtors 1,000 Decrease in creditors (900) Decrease in outstanding salaries (600) Increase in prepaid expenses (80) Cash generated from opertations 34,920 Income tax paid (13,500) Net cash generated from operations 21,420



18

Contd: (B) Cash Flows from Investing Activities Purchase of Building Purchase of Plant and Machinery Purchase of Land Sale of plant Net cash used in Investing Activities (C) Cash Flows from Financing Activities Issue of Shares Capital Security Premium Dividends paid Net cash from financing activities Net increase in cash (A + B + C) Cash in the beginning Cash at the end

(1,000) (20,000) (2,000) 1,200 (21,800) 10,000 2,000 (8,000) 4,000 3,620 6,180 9,800

Significant Non-cash Transaction : Purchase of building by issuing 7% of Mortgage Loan. Note : It is presumed that 7% Mortgage Loan consists of issue of debentures or bonds.

19

Working Notes Retained Earnings Account Dividend paid Balance c/d

Rs. Rs. 8,000 Balance b/d 23,820 30,820 Profit during the year (Balancing Figure)15,000 38,820 38,820 Plant and Machinery Account

Rs. Rs. Balance b/d 62,000 Sale of plant 1,200 Bank-Purchase (Balancing Figure)20,000Depreciation on plant sold14,800 Balance c/d 66,000 82,000 82,000 Accumulated Depreciation on Plant & Machinery Account Plant (Depreciation) Balance c/d

Rs. Rs. 14,800 Balance b/d 37,000 26,200 Profit and Loss Account(Depreciation) 4,000 41,000 41,000

20

Contd: Building Account Rs. Balance b/d 95,000 Cash (Purchase) 1,000 Mortgage Loan (Purchase) 20,000 1,16,000

Balance c/d

Rs. 1,16,000

1,16,000

Accumulated Depreciation on Building Account Balance c/d

Rs. 45,000

Rs. Balance b/d 43,000 Profit and Loss Account(Depreciation) 2,000

45,000 45,000 Provision for Taxation Account Rs. Income tax paid (Balancing Figure)13,500 Balance b/d Balance c/d 1,400 Profit and Loss Account

14,900

Rs. 1,000 13,900

(provision during the year) 14,900

21

Illustration 3 22

Problem Statement The balance sheets of a Sandeep limited company as at 31 March 2008 and 31 March 2009 Note No 1: 07-08 08-09  Reserves 48,000 50,000 

Land & Buildings 1,48,000 1,44,250  Profit & Loss Account 39,690 41,220  Plant & Machinery 1,12,950 1,16,200 

23

Contd:

24

Contd: The following additional information is available from the books: 1. During the year ended 31-3-2009 an interim dividend of Rs. 26,000 and final dividend of Rs. 54,000 were paid. 2. The assets of another company were purchased for Rs.60,000 payable in fully paid shares of the company. These assets consisted of stock Rs. 22,000 and machinery Rs. 29,000. In addition sundry purchases of plant were made totalling Rs. 6,000. 3. Income-tax paid during 2009 was Rs. 25,000.

25

Soluion-3 Cash Flow Statement for Victors Computers Ltd.  For the year Ending 31 March 2009  Cash Flow from Operating Activities 

 

Difference in profit between 31 March 2008 and 31 March 2009 

Rs. 

Rs. 

1,530 

Adjustments for:  Depreciation 

 

 

35,500 

Provision for tax 

 

 

34,000 

Reserves   

 

 

2,000 

Dividends (26,000 + 54,000) 

 

80,000 

Operating profit before tax and working capital changes 

 

1,53,030 

Decrease in Sundry Debtors 

 

12,550 

Decrease in Stock (1,09,040 + 22,000 – 97,370) 

 

33,670 

Increase in Sundry Creditors 

 

2,125 

Decrease in Bills Payable   

 

(22,255) 

Cash generated from operations 

 

1,79,120 

Income tax paid 

 

(25,000) 

 

 

 

Net cash from operating activities 

1,54,120 

26

Contd: Cash from Investing Activities  Purchase of Plant 

 

 

(6,000) 

Purchase of Goodwill 

 

 

(10,000) 

Decrease in advances [Para 15 (e) AS‐3 (Revised)] 

 

1,580 

Net Cash used in investing activities 

 

 

Repayment of Bank Overdraft 

 

(60,000) 

Dividends Paid 

 

(80,000) 

(14,420) 

Cash Flows from Financing Activities   

Net cash used in financing activities 

 

  (1,40,000) 

Net decrease in cash and cash equivalents (A + B + C) 

 

 

(300) 

Cash and cash equivalents at the beginning 

 

 

3,000 

Cash and cash equivalents at the end 

 

 

2,700 

27

Illustration 4 28

Problem Statement 

The following figures have been extracted from the Books of Nikhil Limited for the year ended on 31.3.2004. You are required to prepare a cash flow statement



Net profit before taking into account income tax and income from law suits but after taking into account the following items was Rs. 20 lakhs:

(a) Depreciation on Fixed Assets Rs. 5 lakhs. (b) Discount on issue of Debentures written off Rs. 30,000. (c) Interest on Debentures paid Rs. 3,50,000. (d) Book value of investments Rs. 3 lakhs (Sale of Investments for Rs. 3,20,000). (e) Interest received on investments Rs. 60,000. ( f) Compensation received Rs. 90,000 by the company in a suit filed. (ii) Income tax paid during the year Rs. 10,50,000. (iii)15,000, 10% preference shares of Rs. 100 each were redeemed on 31.3.2004 at a premium of 5%. Further the company issued 50,000 equity shares of Rs. 10 each at a premium of 20% on 2.4.2003. Dividend on preference shares were paid at the time of redemption 29

Contd: Dividends paid for the year 2002-2003 Rs. 5 lakhs and interim dividend paid Rs. 3 lakhs for the year 2003-2004.  (v) Land was purchased on 2.4.2003 for Rs. 2,40,000 for which the company issued 20,000 equity shares of Rs. 10 each at a premium of 20% to the land owner as consideration  (vi) Current assets and current liabilities in the beginning and at the end of the years were as detailed below: 

30

Contd:

Stock Sundry Debtors Cash in hand Bills receivable Bills payable Sundry Creditors Outstanding expenses

As on 31.3.2003 Rs. 12,00,000 2,08,000 1,96,300 50,000 45,000 1,66,000 75,000

As on 31.3.2004 Rs. 13,18,000 2,13,100 35,300 40,000 40,000 1,71,300 81,800

 

31

Solution Cash Flow Statement for the year ended 31st March, 2004 Rs. Rs. Cash flow from Operating Activities Net profit before income tax and extraordinary items: 20,00,000 Adjustments for: Depreciation on fixed assets 5,00,000 Discount on issue of debentures 30,000 Interest on debentures paid 3,50,000 Interest on investments received (60,000) Profit on sale of investments (20,000) 8,00,000 Operating profit before working capital changes 28,00,000

 

32

Contd: Adjustments for: Increase in stock Increase in sundry debtors Decrease in bills receivable Decrease in bills payable Increase in sundry creditors Increase in outstanding expenses

(1,18,000) (5,100) 10,000 (5,000) 5,300 6,800 (1,06,000)

Cash generated from operations 26,94,000 Income tax paid Cash flow from extraordinary items: Compensation received in a suit filed Net cash flow from operating activities

(10,50,000) 16,44,000

90,000 17,34,000

 

33

Contd: Cash flow from Investing Activities Sale proceeds of investments Interest received on investments Net cash flow from investing activities Cash flow from Financing Activities Proceeds by issue of equity shares at 20% premium Redemption of preference shares at 5% premium Preference dividend paid Interest on debentures paid Dividend paid (5,00,000 + 3,00,000) Net cash used in financing activities Net decrease in cash and cash equivalents during the year Add: Cash and cash equivalents as on 31.3.2003 Cash and cash equivalents as on 31.3.2004

3,20,000 60,000 3,80,000 6,00,000 (15,75,000) (1,50,000) (3,50,000) (8,00,000) (22,75,00 0) (1,61,000) 1,96,300 35,300



34

Illustration 5 35

Problem Statement 1. Presented below is the comparative balance sheets for Ashna Ltd. at 31 March : 2006

2005

Rs.

Rs.

Cash

40,000

57,000

Accounts Receivable

77,000

64,000

Inventory Prepaid expenses

1,32,000 1,40,000 12,140

16,540

Land

1,25,000 1,50,000

Equipment

2,00,000 1,75,000

Accumulated Depreciation-Equipment

(60,000)

Building

2,50,000 2,50,000

Accumulated Depreciation-Building

(75,000)

(42,000)

(50,000)

7,01,140 7,60,540 Accounts Payable

33,000

45,000

Bonds Payable

2,35,000 2,65,000

Equity Share Capital (Rs. 10 shares)

2,80,000 2,50,000

Retained Earnings

1,53,140 2,00,540

36

Contd: Additional information : 1.

Operating expenses include depreciation expense of Rs. 70,000 and amortization of prepaid expenses of Rs. 4,400.

2.

Land was sold for cash at book value.

3.

Cash dividends of Rs. 74,290 were paid.

4.

Net income for 2006 was Rs. 26,890.

5.

Equipment was purchased for Rs. 65,000 cash. In addition equipment costing Rs. 40,000 with a book value of Rs. 13,000 was sold for Rs. 15,000 cash.

6.

Bonds were redeemed at face value by issuing 3,000 equity shares of Rs. 10 at par.

Prepare a statement of cash flows for 2006 using the indirect method [AS-3 (Revised)]

37

Solution AshnaLtd.

Cash Flows Statement For the Year Ended 31 December 2006 [AS-3 (Revised)] (Indirect Method) (A)Cash Flows from Operating Activities Net Income 26,890 Adjustments for : Depreciation 70,000 Amortization of prepaid expenses 4,400 Gain on sale of equipment (2,000) Operating profit before working capital changes 99,290 Increase in Accounts Receivable (13,000) Decrease in Inventories 8,000 Decrease in Accounts Payable (12,000) Net cash from operating activities 82,290 38

Contd: (B) Cash

Flows from Investing Activities Sale of Land Sale of Equipment Purchase of Equipment Net cash used in investing activities

25,000 15,000 (65,000) (25,000)

39

Contd:

(C) Cash

Flows from Financing Activities

Dividends Paid

(74,290)

Net cash used in financing activities

(74,290)

Net decrease in cash and cash equivalents (A + B + C)

(17,000)

Cash and cash equivalents at the beginning of the period

57,000

Cash and cash equivalents at the end of the period 40,000 Note: Significant Non-cash Transaction-Redemption of Bonds in exchange for Equity Share Capital Rs. 30,000

40

Working Notes Equity Share Capital Account Rs. Rs. Balance c/d2,80,000 Balance b/d 2,50,000 Bonds Payable Account 30,000 2,80,000 2,80,000

Bonds Payable Accounts Rs. Rs. Balance c/d2,65,000 Balance b/d Equity Share Capital Account 2,65,000

2,35,000 30,000 2,65,000

41

Illustration 6 42

Problem Statement(PCC-Nov 2007) J Ltd. presents you the following information for the year ended 31st March, 2007: (Rs. in lacs) (i)

Net profit before tax provision

36,000

(ii)

Dividend paid

10,202

(iii)

Income-tax paid

(iv)

Book value of assets sold Loss on sale of asset

(v)

Depreciation debited in P & L account

(vi)

Capital grant received - amortized in P & L A/c

(vii)

Book value of investment sold Profit on sale of investment

5,100 222 48 24,000 10 33,318 120

43

Contd: (viii)

Interest income from investment credited in P & L A/c

3,000

(ix)

Interest expenditure debited in P & L A/c

12,000

(x)

Interest actually paid (Financing activity)

13,042

(xi)

Increase in working capital

67,290

[Excluding cash and bank balance] (xii)

Purchase of fixed assets

22,092

(xiii)

Expenditure on construction work

41,688

(xiv)

Grant received for capital projects

(xv)

Long term borrowings from banks

(xvi)

Provision for Income-tax debited in P & L A/c Cash and bank balance on 1.4.2006 Cash and bank balance on 31.3.2007

You are required to prepare a cash flow statement as per AS‐3 (Revised).

18 55,866

6,000 6,000 8,000 44

Solution Cash Flow Statement For the Year Ending 31 March 2006 (A) Cash Flows from Operating Activities Net profit before tax Adjustments for: Depreciation Loss on sale of asset Amortization of Government Grant Profit on sale of investment Interest received Interest paid Operating profit before working capital changes Increase in working capital Cash from operations Tax Paid Net cash used in operating activities

Rs. (in Lakhs) 36,000

Rs.(in Lakhs)

24,000 48 (10) (120) (3,000) 12,000 68,918 (67,290) 1,628 (5,100) (3,472)

45

Contd: (B) Cash Flows from Investing Activities Purchase of fixed assets Interest income Sale of investment (33,318 + 120) Sale of asset (222 – 48) Expenditure on Capital Project Net cash used in investing activity (C) Cash Flows form Financing Activity Dividend Paid Grant Received Interest Paid Long term Borrowing Net Cash provided from financing activity Net increase in cash and cash equivalents (A + B + C) Cash and cash equivalents at the beginning Cash and cash equivalents at the end

(22,092) 3,000 33,438 174 (41,688) (27,168) (10,202) 18 (13,042) 55,866 32,640 2,000 6,000 8,000

46

Illustration 7 47

Problem Statement (PCC-June 2009) From the following summarised Cash account of S Ltd., prepare cash flow  statement for the year ended 31st March, 2009 in accordance with AS 3 (revised)  using direct method. Summarised Cash Account Opening balance Issue of share capital Received from customers Sale of fixed assets

(Rs.000) 50 300 2,800 100

3,250

Payment to suppliers Purchase of fixed assets Overhead expenses Wages and salaries Tax paid Dividend paid Bank loan Closing balance

(Rs.000) 2,000 200 200 100 250 50 300 150 3,250

48

Solution 7

Cash Flow Statement for the year ended 31.3.2009 Cash flow from Operating Activities Rs. in ‘000

Cash received from customers Less:Cash paid to suppliers Cash paid for overhead expenses Cash paid for wages and salaries Less:Income tax paid Net cash generated from Operating Activities

2,800 2,000 200 100 2,300 500 250 250

49

Contd: Cash flow from Investing Activities Sale of fixed assets

100

Less:Purchase of fixed assets

(200)

Net cash used in Investing Activities

(100)

Cash flow from Financing Activities Received from issue of share capital

300

Less: Payment of bank loan

(300)

Payment of dividend

50

350

Net cash used in Financing Activities

(50)

Net increase in cash and equivalents

100

Add:Cash and equivalents at the beginning of the year

50

Cash and equivalents at the end of the year

150

50

THANK YOU

Loading...

Cash Flow Statement - Zeroinfy

Cash Flow Statement IPCC Paper 1/2: Accounting/Financial Management Chapter 2-Unit 2: Cash Flow Statement 1 CA. Pankaj Goel MCQ - Fill in the Blan...

327KB Sizes 2 Downloads 6 Views

Recommend Documents

Cash Flow Statement - Zeroinfy
Questions that Cash Flow Statement Answers. 1. • Where did the cash come from? 2. • What purpose cash used for? 3. â

The cash flow statement
For questions 1 to 10, read the text and decide which answer, A, B or C, best fits each gap. An example (0) has been don

Cash Flow Statement - snl.com
Cash flows from operating activities. Net income, 14,227 · 6,782 · 49,640 · 49,661 · 45,117. Adjustments to reconcile ne

CASH FLOW STATEMENT
This Standard establishes a procedure of preparing a cash flow statement, classifying cash flows into ... example, when

Cash Flow Statement - ncert
generate cash and cash equivalents and the timing and certainty of their ..... Solution: Cash Flows from Operating Activ

Cash flow statement - Wikipedia
US GAAP (FAS 95) requires that when the direct method is used to present the operating activities of the cash flow state

Group cash flow statement
134.9. CASH FLOWS FROM INVESTING ACTIVITIES. Purchase of property, plant & equipment. (18.5). (102.9). Proceeds on dispo

Cash FLOW STATEMENT - ICAZ
cash flows arising from taxes on income are normally classified as operating, unless they can be specifically identified

Cash Flow Statement
The annual accounts. ▫ Balance Sheet. ▫ Income Statement. ▫ Statement of Changes in Equity. ▫ Cash Flow Statemen

IPSAS2 CASH FLOW STATEMENT
The cash flow statement identifies (a) the sources of cash inflows, ... (b) The indirect method, whereby net surplus or