From the given trial balance need to fill the amounts in excel. Unit code FNSACC514 prepare financial report for cooperate entities . please help
Thank you
6:15 Uber 38 M MY FNSACC514 Assessment Workbook (9) - Saved E . . . 1. Prepare a consolidation worksheet Review the AASB 101 Presentation of financial statements document. Create an Excel Workbook that has one Worksheet titled Consolidation Worksheet. In that Worksheet, complete a consolidation worksheet for Mullum Machinery Pty Ltd and Byron Machinery Pty Ltd using the data in Consolidation Information. Save this file as Consolidation Workbook. Template has been uploaded in v-learn. Mullum Machinery Pty Ltd and Byron Machinery Pty Ltd Consolidation Extract of Trial Balance as at 30 June 2017 Mullum Machinery Pty Ltd Byron Machinery Pty Ltd Account $,000 Cr $,000 $,000 Cr $,000 Sales 757 605 Cost of goods sold 247 325 Gross profit 510 280 Interest 24 11 Other income 67 6 Profit on sale of plant 10 Dividends 50 FNSACC514 Prepare Financial Reports for Corporate Entities 27 VIBE COLLEGE General expenses 309 195 Interest 24 Tax 110 35 Net profit 242 43 Retained profits 1/7/13 88 60 Interim dividend paid 45 15 Retained profits 30/6/14 285 88 Bank 41 32 Accounts re 57 92 Plant and equipment 289 485 Investment in Y Ltd 200 Other Investments 110 Share capital 450 General reserve 65 8% debentures Inventories 43 22 Dividend receivable 30 Accounts payable 50 Tax payable 110 8% debentures in Y Ltd 200 970 97 631 886:15 Vo2 46 1 45% % uber FNSACC514 Prepare Financial Reports for Corporate Entities 28 IBE LLEGE Additional information On 1/7/17, Mullum Machinery Pty Ltd purchased all the shares in Byron Machinery Pty Ltd for $225,000 cash. An extract of Byron Machinery Pty Ltd balance sheet on 1/7/17 showed Shareholder's equity of $205,000 comprising Issued Shares $150,000, General reserve $30,000 & Retained profits $25,000. Byron Machinery Pty Ltd paid a dividend of $25,000 from pre-acquisition profits on 1/8/16 Mullum Machinery Pty sold $35,000 worth of goods to Byron Machinery Pty during the year 2 ended 30/6/17 During the same year Mullum Machinery Pty Ltd had sold $11,000 worth of goods to Byron Machinery Pty Ltd. As at 30/6/17, Mullum Machinery Pty Ltd had $10,000 worth of goods on hand. The profit on 3 these goods was $3,000 As at 1/7/17, Mullum Machinery Pty Lid had $6,000 worth of goods purchased from Byron Machinery Pty Ltd which Byron Machinery Pty made a profit of $2,000 5 Mullum Machinery Pty Ltd purchased 8% debentures in Byron Machinery Pty Ltd for $200,000 6 Byron Machinery Pty Ltd was liable to pay Debenture interest on 31/12 and 30/6 each year During the year Byron Machinery Pty Ltd paid $15,000 as interim dividend to Mullum Machinery 7 Pty Ltd On 30/6/17, Byron Machinery Pty Ltd announced a dividend of $30,000. Mullum Machinery Pty 8 included it in accrued income 9 Byron Machinery Pty Lid paid a management fee of $35,000 to Mullum Machinery Pty Ltd On 30/6/17, Byron Machinery Pty Ltd purchased a plant costing $120,000 from Mullum Machinery Pty Ltd. The plant was depreciated by $42,000 and Byron Machinery Pty Ltd was 10 charged $85,000. FNSACC514 Prepare Financial Reports for Corporate Entities 29 m IBE LEGEuber 6:17 -+ 38 M MAY 49 .Ill 45% % Consolidated Workbook Template Assessment 4 - Savec O . . . fx V C D E F G H I J K Mullum Machinery Phy Itd Byron Machinery Phy I tol Coneplidation 510 280 527 469 242 145 285 300 200 970 970 631 631 20 20 1181 O=0
