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 Your work should be prepared using an Excel spreadsheet and saved as a PDF to be submitted via LMS by the due date.