Additional information Soda Ltd had inventory on hand at 30 June 201? that included inventory at cost of $8,000 that had been sold to Soda Ltd by Pepsi Ltd. This inventory had cost Pepsi Ltd $8,000. ltwas all sold by Soda Ltd by 80 June 2018 at a prot of 18,000. During the 201?18 year, Soda Ltd sold inventory to Pepsi Ltd for $48,000. The inventory was carried at cost in Soda Ltd's book at $45,000. At 30 June 2018, Pepsi Ltd still had 50% of this inventory on hand. Notes payables issued by Pepsi Ltd are held by Soda Ltd. Interests are paid on 1 July each year. Required: 1. Prepare an acquisition analysis. 2. Assume they does not prepare consolidated nancial statements. Prepare the consolidated worksheet armies for Pepsi Ltd at 30 June 2018. Show all workings. 3. Prepare the consolidated worksheet for the year ended 30 June 2018 for the inclusion of the equity-accounted results Soda Ltd. Show all workings