Question

In: Accounting

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 expenses totaled Rs.21,45,000. Outstanding expenses on 31st March 2015 and 31st March 2016 totaled Rs.82,000 and Rs.91,000 respectively. (g) New machinery and furniture costing Rs.10,27,500 in all were purchased. (h) 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. (i) Dividends totaling Rs. 4,00,000 were distributed among shareholders. (j) Cash in hand and at bank as of 31st March 2015 totaled Rs.2,13,800. You are required to prepare a cash flow statement using direct method.

Solutions

Expert Solution

Cash Flow Statement (Under Direct Method)

Particulars Working Note No. Amount
A. CASH FLOWS FROM OPERATING ACTIVITIES
Cash Receiplts from Customers 1 96,00,000
Less: Cash Paid to Suppliers 2 (79,16,000)
Cash generated from Operations 16,84,000
Income Tax Paid (7,00,000)
Net Cash flow from Operating Activities 9,84,000
B. CASH FLOWS FROM INVESTING ACTIVITIES  
Purchase of machinery and furniture (13,42,500)
Net Cash used in investing activities (13,42,500)
C. CASH FLOWS FROM FINANCING ACTIVITIES
Issue of Shares (50,000 @13) 650,000
Dividend Paid (4,00,000)
Net Cash Flow from financing activities 150,000
Net Decrease in Casha dn cash equivalents (A + B + C) (208500)
Cash and Cash Equivalents in the begining 213,800
Cash and Cash Equivalents at the end 5300

Working Note:

1) Cash Receipts from Customers

Sales = 96,00,000

2) Cash Paid to Suppliers

Cost of goods sold = 57,60,000

Add: Operating Expenses =  21,45,000

Add: Outstanding Expenses at begining = 82000

Add: Closing inventory exceeded = 43,000

Less: Outstanding Expenses at the end = (91,000)

Less: Trade Creditors exceeded = (23,000)

Cash Paid to suppliers = 79,16,000

3) Machinery and Furniture = 10,27,500

Add: Depreciation = 315,000

Purchase of machinery and furniture= 13,42,500


Related Solutions

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...
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 Income Statement of Adom Enterprise for the year ended 31st March, 2020 as prepared by...
The Income Statement of Adom Enterprise for the year ended 31st March, 2020 as prepared by an AccountsAssistantindicatedanetprofitofGHS148,080.Though,thecashbookon31st March,2020 showed a balance at bank to be GHS 13,460. Your attention is however drawn to the following: i) Cheques from customers totalling GHS 14,940 which were recorded in the cash book on March 25, 2020 were not credited by the bank until April 2, 2020. ii) Cheques issued on March 13, 2020 totalling GHS 22,260 in favour of suppliers were not...
The following information relates to Walnut Ltd. for the year ended December 31, 2013: Sales                          &nbsp
The following information relates to Walnut Ltd. for the year ended December 31, 2013: Sales                                                                                                         $3,500,000 Purchases: Direct materials                                                                                   $700,000 Indirect materials                                                                                 $50,000 Office supplies                                                                                     $20,000       Salaries                                                                                                      $500,000 * Direct labour                                                                                              $800,000       Rent                                                                                                          $100,000 *       Utilities                                                                                                     $80,000 *       Advertising and promotional                                                                     $30,000       Inventories:                             Dec. 31, 2012                      Dec. 31, 2013 Direct materials                $45,000                                $62,000 Indirect materials                 -----                                  $ 9,000 Office supplies                  $1,000                                     ----- Work-in-process               $4,100                                   $3,300 Finished goods                  $90,000                                 $81,700 *Of these costs, 80 % are assigned to manufacturing activities and the remainder pertain to selling and administrative functions.                         (Assume that there is no "over-or-under" applied overhead.) Instructions: Prepare in good form...
The following information is related to Sunglow Solar Ltd: Sales for the year ended 30 June...
The following information is related to Sunglow Solar Ltd: Sales for the year ended 30 June 2019 was $1,200,000 Provision for warranties before adjustment was $36,000 At 30 June 2019, Sunglow Solar Ltd. adjusted its Provision for Warranties so that it would be equal to 4% of sales for the year ended on that date. On 16 September 2019, a successful claim for warranty on faulty goods to the cost of $700 was made on Sunglow Solar Ltd. Required: Prepare...
The Following are extracts from the financial statements of Wewe Ltd. As at 31st March: 2018...
The Following are extracts from the financial statements of Wewe Ltd. As at 31st March: 2018 2017 Shs ‘000’ Shs ‘000’ Shs ‘000’ Shs ‘000’ Fixed assets: 2,800 2,900 Goodwill 16,800 12,000 Freehold Land & building 5,860 6,350 Plant & Machinery (NBV) 3,600 3,750 Investment at cost 29,060 25,000 Current Assets: 10,050 8,700 Stock 6,140 7,800 Accounts receivable 1,710 840 Investment 200 430 Cash at hand & bank 18,100 17,770 Current Liabilities: (2,390) (6,540) Bank overdraft (5,850) (5,250) Account Payable...
XYZ Sdn Bhd is preparing budget for the year ended 31st December 2016. The company manufactures...
XYZ Sdn Bhd is preparing budget for the year ended 31st December 2016. The company manufactures and sellls one product at RM5 each but this will increase to RM6 from 1st July 2016. The budget sales volume are: Units January to June 9,000 July to December 6,000 Sales for January to June 2017 is expected to be 12,000 units. Closing stocks is budgeted at 10% of the next six month period’s sales. No stocks of components are held. Each unit...
XYZ Sdn Bhd is preparing budget for the year ended 31st December 2016. The company manufactures...
XYZ Sdn Bhd is preparing budget for the year ended 31st December 2016. The company manufactures and sellls one product at RM5 each but this will increase to RM6 from 1st July 2016. The budget sales volume are: Units January to June 9,000 July to December 6,000 Sales for January to June 2017 is expected to be 12,000 units. Closing stocks is budgeted at 10% of the next six month period’s sales. No stocks of components are held. Each unit...
The following information relates to Egoly Ltd for the year ended 30th June 2019: EGOLY LTD...
The following information relates to Egoly Ltd for the year ended 30th June 2019: EGOLY LTD BALANCE SHEET AS AT 30th JUNE 2019 2019 2018 $ $ ASSETS Current Assets    Cash at bank 67,710 59,666    Accounts receivable 252,760 283,290    Inventory 1,107,600 951,400    Prepaid expenses 113,600 35,500 Total current assets 1,541,670 1,329,856 Non-current assets    Equipment 1,263,800 823,600    Accumulated depreciation – equipment (238,560) (143,136) Total non-current assets 1,025,240 680,464 TOTAL ASSETS 2,566,910 2,010,320 LIABILITIES & SHAREHOLDERS...
Alpha Ltd. Has the following details as on March 31, 2016                                 
Alpha Ltd. Has the following details as on March 31, 2016                                  2016 2015 Sales 2250 2000 Opening stock 30 20 Production 2460 2000 Closing stock 400 30 Cost of goods sold (opening stock + production – Closing stock) 2090 1990 Other expenses 80 50 Net Profit/Loss 80 (40) Suppose the accountant has wrongly computed the closing stock while adding stocks, to an extent of 30%. What would be the impact on the profit of the Alpha Ltd compare to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT