please, can i get answer in excel?

pl

The statements of financial position for Cube and Prism as at 31 December 20X1 are presented below: Assets Cube Prism Non-current assets 5 5 Property, plant and equipment 270,000 179,000 Investments 300,000 Current assets Inventories 95,000 50,000 Trade and other receivables 110,000 99,000 Cash and cash equivalents 8,000 51,000 Total assets 783,000 379,000 Equity and liabilities Equity Share capital 80,000 40,000 Revaluation surplus 20,000 10,000 Retained earnings 435,000 209,000 tiabiiities Long-term loans 200,000 70,000 Trade and other payables 48,000 50,000 Total equity and liabilities 783,000 379,000 The following notes are relevant to the preparation of the consolidated nancial statements: (i) Cube acquired 75% of the ordinary shares of Prism for $300,000 several years ago. At the acquisition date, the retained earnings of Prism were $120,000 and revaluation surplus was $10,000. The fair value of the non-controlling interest at the date of acquisition was $55,000. (ii) The fair values of the net assets of Prism at the acquisition date approximated their carrying amounts, with the exception of some land. This land was held in the financial statements of Prism at its cost of $100,000 but was estimated to have a fair value of $170,000. This land is still held at 31 December 20X1. (iii) During the year, Cube sold goods to Prism for $30,000 making a gross profit margin on the sale of 30%. One third of these goods are still included in the inventories of Prism. Rguired: l Prepare the consolidated statement of nancial position for the Cube group as at 31 December 20X1. (11 marks) a_-4_