Question

In: Accounting

The following information is available from the books of Exclusive Ltd. for the year ended 31st...

The following information is available from the books of Exclusive Ltd. for the year ended 31st March 2016: (a) Cash sales for the year were Rs.10,00,000 and sales on account Rs.12,00,000. (b) Payments on accounts payable for inventory totaled Rs.7,80,000. (c) Collection against accounts receivable were Rs.7,60,000. (d) Rent paid in cash Rs.2,20,000, outstanding rent being Rs.20,000. (e) 4,00,000 Equity shares of Rs.10 par value were issued for Rs.48,00,000. (f) Equipment was purchased for cash Rs.16,80,000. (g) Dividend amounting to Rs.10,00,000 was declared, but yet to be paid. (h) Rs.4,00,000 of dividends declared in the previous year were paid. (i) An equipment having a book value of Rs.1,60,000 was sold for Rs.2,40,000. (j) The cash account was increased by Rs.37,20,000. Prepare a cash flow statement using direct method.

Solutions

Expert Solution

In the books of Exclusive Limited:

Calculation of Net Cash Flow from Direct Method:

Particulars Amount
Cash Flow from Operating Activities
Cash Inflow
Cash Sales for the year                    10,00,000
Collection against Accounts Receivable                      7,60,000
Cash outflow
Payments on accounts payable                    -7,80,000
Rent Paid in cash                    -2,20,000      7,60,000
Cash Flow from Investing Activities
Cash Inflow
Assets sold for Cash                      2,40,000
Cash outflow
Equipement Purchased                  -16,80,000 -14,40,000
Cash Flow from Financing Activities
Cash Inflow
Issue of shares including premium                    48,00,000
Cash outflow
Dividend Paid                    -4,00,000    44,00,000
Net cashflow    37,20,000
Notes for Understanding & Workings:
1. On Account Sales were ignored since it is not related to cash
2. Oustanding Rent is not related to cash hence ignored.
3. Dividend declared is not considerable while using direct method since there is no cash flow. Hence Ignored
4. Assets sale value is considered because it is linked with cash inflow.
5. Given cash increament of 37,20,000 is matching with the our Net cash flow
Note for Student:
Hi Dear Friend , I hope I have satisfied your given problem from the above solution. Still let me know in comments section in case you have any doubts.

Related Solutions

The following information relates to ABC Ltd., for the year ended 31st December, 2019.
The following information relates to ABC Ltd., for the year ended 31st December, 2019.             Sales……………………………………………………………….. Rs.2,000,000.             EBID ………………………………………………………………. 40% of sales.             Ordinary Shares capital of par value Rs.10/each……………… Rs.800,000.             8% Preference shares Capital of par value Rs.100/ each………. Rs.500,000.             10% Bonds payable of par value Rs.1000/each…………………. Rs.400,000.             Reserves and surplus………………………………………………Rs.250,000.             Current liabilities…………………………………………………..Rs.250,000. Tax rate is 30%.             Market price of share is Rs.20 each.             Dividend payout ratio is 60%. Required; Compute and comments on each of the following ratios a)Earning per...
The information below was extracted from the books of Battle Field Ltd for the year ended...
The information below was extracted from the books of Battle Field Ltd for the year ended December 31, 2019. Battle Field Ltd. Condensed Income Statement For the Year Ended December 31, 2019 Sardines GHS Tuna Flakes GHS Oatmeal GHS Total GHS Sales 500,000 400,000 100,000 1,000,000 Costs of goods sold: Variable costs Fixed costs 220,000 120,000 200,000 80,000 60,000 20,000 480,000 220,000 Total cost of goods sold 340,000 280,000 80,000 700,000 Gross profit 160,000 120,000 20,000 300,000 Operating expenses: Variable...
Madhuri Ltd. gives you the following information for the year ended 31st March 2016: (a) Sales...
Madhuri Ltd. gives you the following information for the year ended 31st March 2016: (a) Sales for the year totaled Rs.96,00,000. The company sells goods for cash only. (b) Cost of goods sold was 60% of sales. (c) Closing inventory was higher than opening inventory by Rs.43,000. (d) Trade creditors on 31st March 2016 exceeded those on 31st March 2015 by Rs.23,000. (e) Tax paid amounted to Rs.7,00,000. (f) Depreciation on fixed assets for the year was Rs.3,15,000 whereas other...
The following information are the balances extracted from the books of Xxx for the year ended...
The following information are the balances extracted from the books of Xxx for the year ended 31 December 2017: accounts                  dr                        cr opening stock        8000 buildings                 15000 debitors                  4000 purchases               22000 salaries                    1200 sales                                                   36000 discount                  800 sales returns          1000 furniture                 3000 office exp               300 wages                      600 purchase returns                               600 interest                                                  500 travelling exp         400 insurance                 600 machinery              8000 carriage on purchases 800 commission           600 cash in hand          1400 rent and rates         2400 capital                                                   25000 creditors                                                8000 totals                      70100                   70100...
The following selected information is available for Jones & Co. Ltd., for the year ended 31 December 20X8:
The following selected information is available for Jones & Co. Ltd., for the year ended 31 December 20X8: Other Information:1. Equipment with an original cost of $100,000 was sold for cash.2. Other equipment was bought for cash.3. There is no income tax expense.4. Cash dividends were paid during the year as well as a $50,000 stock dividend that reduced retained earnings and increased common shares. Required:Present, in good form, the operating, investing, and financing section of the SCF for the...
The following information is available from the accounting records of Manahan Co. for the year ended...
The following information is available from the accounting records of Manahan Co. for the year ended December 31, 2016: Net cash provided by financing activities $ 118,000 Dividends paid 18,400 Loss from discontinued operations, net of tax savings of $41,367 124,100 Income tax expense 27,355 Other selling expenses 12,000 Net sales 649,200 Advertising expense 46,500 Accounts receivable 57,000 Cost of goods sold 370,044 General and administrative expenses 142,500 a. Calculate the operating income for Manahan Co. for the year ended...
Following information is extracted from the books of a manufacturing concern on 31st December Opening stock...
Following information is extracted from the books of a manufacturing concern on 31st December Opening stock of raw material 13,000 Furniture and Fixtures 72,000 Plant and Machinery 98,000 Bank charges 5,453 Cash in hand 12,800 Cost of material available for use 62,000 Opening inventory of finished goods 8,000 Cost of direct material used 50,000 Sundry creditors 54,000 Direct labour cost 10,000 Sundry debtors 20,000 Factory overhead cost 5,000 Loan taken from bank 44,300 Sales 85,000 Cost of goods available for...
The following information was extracted from the records of Dolphin Ltd for the year ended 30...
The following information was extracted from the records of Dolphin Ltd for the year ended 30 June 20X1 · Cost of equipment that was sold: $530,000 · Accumulated depreciation for equipment that was sold: $310,000 · Cost of equipment that was purchased: $510,000 · Gain on sale of equipment: $50,000 Required: Write in the box below the net cash used for investing activities for the year ended 30 June 20X1.
The FOllowing information from the accounts of kesha Ltd for the year ended December 31, 2009...
The FOllowing information from the accounts of kesha Ltd for the year ended December 31, 2009 has been provided to you: Net icome................................2,090,000 Amortization of intangible assert.............120,000 Proceeds from issue of ord. share...........1,030,000 Increase in inventory...............................180,000 Sale of building at shs 100,000 gain........850,000 Increase in accounts payable...........150,000 Purchase of computer equipment........1,250,000 Payments of cash dividends..............240,000 Depreciation expense...................350,000 Increase in accounts receivable...........230,000 Payment of mortagage.................520,000 Decrease in short-term notes payable.......80,000 Sale of land at shs 50,000 loss............260,000 Purchase of delivery truck.................330,000...
The following information is available from TJ Foods Inc. for the year ended December 31, 2019:...
The following information is available from TJ Foods Inc. for the year ended December 31, 2019:                            At Cost At Retail Sales 100000 Purchases 48000   90000 Inventory January 1, 2019    24000 54000 Net Additional Markups 12000 Net Markdowns 6000 Required a)What is the inventory cost on December 31, 2019 under the average cost retail method (Non LCM)? b) What is the inventory cost on December 31, 2019 under the retail method on FIFO...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT