is urgent pls. no excel solution. if possible add explanations

ASSIGNMENT EIGHT The statements of financial position of three entities at 30 June 2019 are given below: Red GH000 Blue GH000 Green GH000 4,250 9,300 10,000 3,600 550 Non-current asset Property, plant and equipment Investment Current asset Inventory Receivables Cash Equity share capital (GH1 shares) Retained earnings Non-current Liabilities Current liabilities 1,750 1,050 1,550 23,650 1,500 4,150 2,000 2,500 23,650 700 550 1,010 9,860 7,000 730 750 1,380 9,860 400 420 330 5,400 4,000 870 250 280 5.400 i) On 1 July 2018 Red acquired 60% of the equity share capital of Blue for GHm cash. The retained earnings of Blue were GH500,000 and the fair value of the NCI holding was GH 3.5m. On the same date, Red acquired 60% of the equity share capital of Green for GH4m cash. The retained earnings of Green were GH570,000 and the fair value of the NCI holding was GH2.5m ii) On 30 June 2019, Blue acquired 10% of the equity share capital of Green for GH 1m cash. At 1 July 2018, property, plant and equipment in the books of Blue had a fair value of GH250,000 in excess of its carrying value. The items had a remaining useful economic life of 5 years at this time. iii) At 30 June 2019, Blue and Green held goods in inventory which had been purchased from a total of GH360,000. Red had sold the goods at a 20% mark up. iv) At 30 June 2019, goodwill arising on the acquisition of Blue had been impaired by GH 250,000 and the goodwill arising on the acquisition f Green had been impaired by GH130,000. It is group policy to measure NCIs at fair value at acquisition. Required: Prepare the consolidated statement of financial position at 30 June 2019