Hi Tutors,

Please help to show the working clearly and present in the excel file.

Regards,

Lyn

BUS356 Semester 1, 2017 Group assignment Weight of overall mark: 25% This assignment is to be completed in a pair of 2 students only. Submission: Please submit a Word copy through LMS link and keep a copy for your th own records. The submission is due by 5:00pm Wednesday 5 April 2017. On 1 July 2016, Parrot Ltd acquired 80% of the share capital of Squirrel Ltd for $264 800. On that date, the statement of financial position of Squirrel Ltd consisted of: Share capital General reserve Asset revaluation surplus Retained earnings Liabilities Cash Inventories Land Plant and equipment Accumulated depreciation - plant and equipment Trademark Goodwill $250 000 10 000 15 000 10 000 180 000 $465 000 $ 35 000 70 000 65 000 300 000 (130 000) 100 000 25 000 $ 465 000 At 1 July 2016, all identifiable assets and liabilities of Squirrel Ltd were recorded at fair value except for: Inventories Land Plant and equipment (cost $200 000) Trademark Carrying amount $ 70 000 65 000 70 000 Fair value $ 80 000 85 000 90 000 100 000 110 000 During the year ended 30 June 2017, all inventories on hand at the beginning of the year were sold, and the land was sold on 28 February 2017 to Outback Ltd for $80 000. The plant and equipment had a further 5-year life beyond 1 July 2016 and was expected to be used evenly over that time. The trademark was considered to have an indefinite life. Any adjustments for differences at acquisition date between carrying amounts and fair values are made in the consolidation worksheet. Parrot Ltd uses the partial goodwill method. The tax rate is assumed to be 30%. Financial information for Parrot Ltd and Squirrel Ltd for the year ended 30 June 2017 is shown below. Parrot Ltd Squirrel Ltd $200 000 $172 000 Sales revenue 1 Other income Cost of sales Other expenses Profit from trading Gains/(losses) on sale of non-current assets Profit before tax Income tax expense Profit for the period Retained earnings (1/7/16) Transfer from general reserve Interim dividend paid Final dividend declared Retained earnings (30/6/17) Asset revaluation surplus (1/7/16) Gain on revaluation of specialised plant Asset revaluation surplus (30/6/17) 75 000 275 000 162 000 53 000 215 000 60 000 10 000 30 000 202 000 128 000 31 000 159 000 43 000 5 000 70 000 20 000 50 000 30 000 80 000 12 000 6 000 18 000 $ 62 000 48 000 18 000 30 000 10 000 8 000 48 000 10 000 4 000 14 000 $ 34 000 $ 15 000 5 000 $ 20 000 During the year ended 30 June 2017, Squirrel Ltd sold inventories to Parrot Ltd for $8000. The original cost of these items to Squirrel Ltd was $5000. One-third of these inventories were still on hand at the end of the year. On 31 March 2017, Squirrel Ltd transferred an item of plant with a carrying amount of $10 000 to Parrot Ltd for $15 000. Parrot Ltd treated this item as inventories. The item was still on hand at the end of the year. Squirrel Ltd applied a 20% depreciation rate to this type of plant. Required: 1. Prepare the acquisition analysis and all consolidation worksheet entries (narrations not required) necessary for preparation of the consolidated financial statements for Parrot Ltd and its subsidiary for the year ended 30 June 2017. 2. Prepare the consolidated statement of profit or loss and other comprehensive income for Parrot Ltd and its subsidiary at 30 June 2017. Hints: 1) The acquisition analysis calculates goodwill acquired by Parrot Ltd acquiring Squirrel Ltd. It should not included any goodwill that is currently in the books of Squirrel Ltd. 2) Existing goodwill that is already present in the books of Squirrel Ltd is not subject to any revaluation so when completing the Business combination valuation entries existing goodwill is written off. 3) The $80,000 is for the land that was sold to Outback Ltd. 4) The plant that Squirrel transferred was considered inventories in the books of Parrot so any reversal of gain or loss should be done against inventories and not against plant. 2