Can I have the answer in excel format? And also please try to answer the question C with the provided consolidation worksheet template.

Required A. B. Prepare the acquisition analysis and BCVR entries of Benson Lid at 1 July 2019 (10 marks) C Prepare the consolidation worksheet entries at 30 June 2020. Complete the consolidation worksheet at 30 June 2020. (Suggested template below).(10 marks) (10 marks) Consolidation Worksheet at 30 June 2020 Benson Led Benson Ltd Brac. Ltd Adjustments Group Dr Cr Profit before tax 120 000 12 500 Income tax expense (56 000) (4 200) Profit 64 000 8 300 Retained earnings (1/7/19) 80 000 36 000 Transfer from BCVR 144 000 44 300 Transfer to general reserve (0) (3 000) Retained earnings (30/6/20) 144 000 41 300 Share capital 360 000 54 000 BCVR General reserve 10 000 3 000 514 000 98 300 Asset revaluation surplus (1/7/19) 13 500 18 000 Gains 5 000 2 000 Asset revaluation surplus (30/6/20) 18 500 20 000 532 500 118 300 Liabilities 42 500 13 000 575 000 131 300 Land 160 000 20 000 Plant & machinery 360 000 25 600 Accum. depreciation (110 000) (33 000) Inventory 55 000 18 700 Shares in Brac, Ltd 1 10 000 0 575 000 131 300