Please prepare using an Excel spreadsheet

Prepare the acquisition analysis at 1 July 2013.

Required: A. Prepare the acquisition analysis at 1 July 2013 B. Prepare the BCVR and pre-acquisition journal entries at 1 July 2013. C. Prepare the BCVR and pre-acquisition journal entries at 30 June 2017. D. Prepare the consolidation worksheet journal entries to eliminate the effects of inter-entity transactions as at 30 June 2017 E. Prepare the consolidation worksheet for the preparation of the consolidated financial statements for the period ended 30 June 2017 F. Prepare the consolidated statement of profit or loss and other comprehensive income, the consolidated balance sheet and the consolidated statement of changes in equity for the period ended 30 June 2017 Presentation Your work should be prepared using an Excel spreadsheet and saved as a PDF to be submitted via LMS by the due date PLEASE NOTE It is the responsibility of each group member to check the entire assignment prior to submission Each group member must read and sign the Plagiarism Declaration on the Cover Sheet placed on LMS under the Assessments Tab. Please include this cover sheet as the first page in your submitted assignment. Required: A. Prepare the acquisition analysis at 1 July 2013 B. Prepare the BCVR and pre-acquisition journal entries at 1 July 2013. C. Prepare the BCVR and pre-acquisition journal entries at 30 June 2017. D. Prepare the consolidation worksheet journal entries to eliminate the effects of inter-entity transactions as at 30 June 2017 E. Prepare the consolidation worksheet for the preparation of the consolidated financial statements for the period ended 30 June 2017 F. Prepare the consolidated statement of profit or loss and other comprehensive income, the consolidated balance sheet and the consolidated statement of changes in equity for the period ended 30 June 2017 Presentation Your work should be prepared using an Excel spreadsheet and saved as a PDF to be submitted via LMS by the due date PLEASE NOTE It is the responsibility of each group member to check the entire assignment prior to submission Each group member must read and sign the Plagiarism Declaration on the Cover Sheet placed on LMS under the Assessments Tab. Please include this cover sheet as the first page in your submitted assignment