How do I prepare the consolidation worksheet for the preparation of the consolidated financial statements for the period ended 30 June 2017?

On 1 July 2013 Donald Ltd acquired all of the share capital (cum div) of Duck Limited for a consideration of $500,000 cash and a brand that was held in their accounts at a book value of $10,000 but at 1 July 2013 had a fair value of $34,000. Duck Ltd reported a dividend payable of $10,000 at 1 July 2013. At that date all the identifiable assets and liabilities were recorded at fair value with the exception of: ASSET Inventory Land Plant MARKET VALUE $14000 $30,000 BOOK VALUE $10,000 $25,000 $20,000 13,000) $17,000 $16,000 Less depreciation $22,000 $14,000 Accounts Receivable The inventory was all sold by 30/6/14. The remaining useful life of the plant is 5 years. The accounts receivable were collected by 30/6/14 for $14,000. The land was sold on 30/12/16 for $32,000. The plant was on hand still at 30/6/17. At the date of acquisition the equity of Duck Ltd consisted of: Share Capital General Reserve Retained Earnings 380,000 70,000 62,000 Information from the trial balances of Donald Ltd and Duck Ltd at 30 June 2017 is presented overleaf on page 3. Additional Information 1. On 1 Jan 2017 Duck Ltd sold inventory to Donald Ltd costing $60,000 for $80,000. Half of this inventory was sold to outside parties for $30,000 by 30/6/17. 2. On 1 Jan 2016 Duck Ltd sold inventory costing $9000 to Donald Ltd for $12,000. Donald Ltd treats the item as equipment and depreciates it at 10% per annum. 3. On 1 July 2016 Duck sold plant to Donald for $12,000. The plant had cost Duck $10,000 on 1 July 2014 and it was being depreciated at 10% per annum. Donald regards the plant as inventory. The inventory was all sold by 30th July 2016. 4. At 1 July 2016 Duck Ltd held inventory that it had purchased from Donald Ltd on 1 June 2016 at a profit of $7000. All inventory was sold by 30 June 2017 5. Donald Ltd accrues dividends from Duck Ltd once they are declared. 6. Donald Ltd has earned $1200 in interest revenue in the 2017 financial year from Duck Ltd. 7. Donald Ltd has earned $4800 in service revenue in the 2017 financial year from Duck Ltd. 8. Assume a tax rate of 30%. Duck Ltd DR CR 932,500 Donald Ltd DR CR 1,192,500 888,000 61,000 5,200 3,500 7,000 4,000 676,000 32,000 4,800 4,800 1,200 6,000 4,800 1,200 16,000 7,000 5,000 7,000 97,120 118,480 100,820 70,280 10,000 12,000 7,000 9,000 Sales Revenue Cost of Sales Wages and Salaries Depreciation Expense Service Expense Interest Expense Other Expenses Gain on Sale of Non Current Ass Service Revenue Interest Revenue Dividend Revenue Income tax expense Retained Earnings 1/7/16 Dividend Paid Dividend Declared Share Capital General Reserve Other Equity 1/7/16 Gains on Financial Assets (OCI) Loan Payable to Donald Ltd Deferred Tax Liability Dividend Payable Shares in Duck Ltd Cash Inventories Other Current Assets Dividend Receivable Loan receivable from Duck Ltd Financial Assets Plant and Equipment Acc. Depreciation Plant Land 500,000 146,000 4,000 1,000 380,000 70,000 12,000 6,000 16,000 30,000 9,000 52,000 12,000 147,500 36,000 300,000 524,000 86,000 169,500 11,000 9,000 16,000 15,000 52,000 68,000 28,000 10,000 14,000 70,000 2,040,320 120,000 1,558,780 2,040,320 1,558,780 On 1 July 2013 Donald Ltd acquired all of the share capital (cum div) of Duck Limited for a consideration of $500,000 cash and a brand that was held in their accounts at a book value of $10,000 but at 1 July 2013 had a fair value of $34,000. Duck Ltd reported a dividend payable of $10,000 at 1 July 2013. At that date all the identifiable assets and liabilities were recorded at fair value with the exception of: ASSET Inventory Land Plant MARKET VALUE $14000 $30,000 BOOK VALUE $10,000 $25,000 $20,000 13,000) $17,000 $16,000 Less depreciation $22,000 $14,000 Accounts Receivable The inventory was all sold by 30/6/14. The remaining useful life of the plant is 5 years. The accounts receivable were collected by 30/6/14 for $14,000. The land was sold on 30/12/16 for $32,000. The plant was on hand still at 30/6/17. At the date of acquisition the equity of Duck Ltd consisted of: Share Capital General Reserve Retained Earnings 380,000 70,000 62,000 Information from the trial balances of Donald Ltd and Duck Ltd at 30 June 2017 is presented overleaf on page 3. Additional Information 1. On 1 Jan 2017 Duck Ltd sold inventory to Donald Ltd costing $60,000 for $80,000. Half of this inventory was sold to outside parties for $30,000 by 30/6/17. 2. On 1 Jan 2016 Duck Ltd sold inventory costing $9000 to Donald Ltd for $12,000. Donald Ltd treats the item as equipment and depreciates it at 10% per annum. 3. On 1 July 2016 Duck sold plant to Donald for $12,000. The plant had cost Duck $10,000 on 1 July 2014 and it was being depreciated at 10% per annum. Donald regards the plant as inventory. The inventory was all sold by 30th July 2016. 4. At 1 July 2016 Duck Ltd held inventory that it had purchased from Donald Ltd on 1 June 2016 at a profit of $7000. All inventory was sold by 30 June 2017 5. Donald Ltd accrues dividends from Duck Ltd once they are declared. 6. Donald Ltd has earned $1200 in interest revenue in the 2017 financial year from Duck Ltd. 7. Donald Ltd has earned $4800 in service revenue in the 2017 financial year from Duck Ltd. 8. Assume a tax rate of 30%. Duck Ltd DR CR 932,500 Donald Ltd DR CR 1,192,500 888,000 61,000 5,200 3,500 7,000 4,000 676,000 32,000 4,800 4,800 1,200 6,000 4,800 1,200 16,000 7,000 5,000 7,000 97,120 118,480 100,820 70,280 10,000 12,000 7,000 9,000 Sales Revenue Cost of Sales Wages and Salaries Depreciation Expense Service Expense Interest Expense Other Expenses Gain on Sale of Non Current Ass Service Revenue Interest Revenue Dividend Revenue Income tax expense Retained Earnings 1/7/16 Dividend Paid Dividend Declared Share Capital General Reserve Other Equity 1/7/16 Gains on Financial Assets (OCI) Loan Payable to Donald Ltd Deferred Tax Liability Dividend Payable Shares in Duck Ltd Cash Inventories Other Current Assets Dividend Receivable Loan receivable from Duck Ltd Financial Assets Plant and Equipment Acc. Depreciation Plant Land 500,000 146,000 4,000 1,000 380,000 70,000 12,000 6,000 16,000 30,000 9,000 52,000 12,000 147,500 36,000 300,000 524,000 86,000 169,500 11,000 9,000 16,000 15,000 52,000 68,000 28,000 10,000 14,000 70,000 2,040,320 120,000 1,558,780 2,040,320 1,558,780