HILL 5 poll... H4 of 2 Draw Highlight v Erase 8 DE + DLA Read aloud TEAM PROJECT: CONSOLIDATED ITNANCIAL STATEMENTS Question One (20 marks) Madari Ltd purchased 100% of the shares of Concerto Ltd on 1 July 2020 for $70,000. On the date of acquisition, the equity of the two entities was as follows: Madari Ltd($) General Reserve Retained Earnings Share Capital 25,000 4,500 60,000 Concerto Ltd ($) 5,500 3,300 38,000 At 1 July 2020, all of the identifiable assets and liabilities of Concerto Ltd were recorded at fair value except for the following: Inventory Plant and Equipment Carrying Amount ($) 3,000 60,000 Fair Value ($) 4,500 65,000 The plant and equipment had a further 5-year useful life. Any valuation adjustments are made on consolidation. All of the inventories were sold by December 2020. The assets of Concertu Ltd included Goodwill with a value of $5,000. Financial information for both entities for the year ended 30 June 2022 is shown below. Madari Ltd Concerto Ltd 20,000 Sales revenue Dividend revenue 39,000 2,200 800 hp + A Read aloud Draw Highlight v Erasele Madari Ltd Concerto Ltd Sales revenue Dividend revenue 39,000 2,200 20,000 800 Total income 41,200 20,800 Cost of sales Other expenses 30,000 5,400 15,000 2,500 Total expenses 35,400 17,500 Gross profit Gain on sale of equipment 5,800 0 3,300 2,400 Profit before income tax 5,700 5,800 1,500 Income tax expense 1,745 Profit for the period Retained earnings (1/7/21) 4,300 7,250 3,955 4,500 11,550 8,455 Interim dividend paid Final dividend declared 2,000 4,000 1,000 1,200 Retained earnings (30/6/22) 5,500 6,255 ONS CU Highlight Erase a B + A Read aloud y Draw Additional information a) On the 1 January 2022, Madari Ltd advanced $50,000 to Concerto Ltd. The interest rate on the advance is 6%p.a payable monthly. b) Madari Ltd records dividend receivable as revenue when dividends are declared. c) The beginning inventories of Concerto Ltd at 1 July 2021 included goods which cost Concerto Ltd $1,000. Concerto Ltd purchased these inventories from Madari Ltd for $1,330 d) Intragroup sales totalled $5,000 for the period ended 30 June 2022. Sales from Madari Ltd to Concerto Ltd, at cost plus 10% mark-up, amounted to $2,800. The ending inventories of Madari Ltd included goods which cost Madari Ltd $2,200. Madari Ltd purchased these inventories from Concerto Ltd at cost plus 10% mark-up. e) On 31 December 2021, Concerto Ltd sold an item of equipment to Madari Ltd for $15,000. This equipment originally cost Concerto Ltd $15,000 but at the time of the intragroup sale it had a carrying amount of $12,600. Madari Ltd depreciates the equipment at the rate of 10% p.a. on cost. Concerto depreciated the equipment at 8% p.a. on cost. The sales revenue account for Madari Ltd includes $3,000 earned from professional services provided to Concerto Ltd in the year ended 30 June 2022. g) The income tax rate is 30%. ii. Required i. Prepare the acquisition analysis at 1 July 2020. ii. Prepare the business combination valuation entries and pre-acquisition entries at 30 June 2021. Prepare the business combination valuation entries and pre-acquisition entries at 30 June 2022 iv. Prepare the consolidation worksheet journal entries to eliminate the effects of intragroup transactions at 30 June 2022. Prepare the consolidation worksheet (in an Excel Spreadsheet) for the preparation of the consolidated statement of financial performance for the year ended 30 June 2022. Totals in your Excel spreadsheet should be calculated using functions. vi. Using the consolidated worksheet, prepare the consolidated statement of profit or loss and other comprehensive income for the period ended 30 June 2022 within Excel. V. HILL 5 poll... H4 of 2 Draw Highlight v Erase 8 DE + DLA Read aloud TEAM PROJECT: CONSOLIDATED ITNANCIAL STATEMENTS Question One (20 marks) Madari Ltd purchased 100% of the shares of Concerto Ltd on 1 July 2020 for $70,000. On the date of acquisition, the equity of the two entities was as follows: Madari Ltd($) General Reserve Retained Earnings Share Capital 25,000 4,500 60,000 Concerto Ltd ($) 5,500 3,300 38,000 At 1 July 2020, all of the identifiable assets and liabilities of Concerto Ltd were recorded at fair value except for the following: Inventory Plant and Equipment Carrying Amount ($) 3,000 60,000 Fair Value ($) 4,500 65,000 The plant and equipment had a further 5-year useful life. Any valuation adjustments are made on consolidation. All of the inventories were sold by December 2020. The assets of Concertu Ltd included Goodwill with a value of $5,000. Financial information for both entities for the year ended 30 June 2022 is shown below. Madari Ltd Concerto Ltd 20,000 Sales revenue Dividend revenue 39,000 2,200 800 hp + A Read aloud Draw Highlight v Erasele Madari Ltd Concerto Ltd Sales revenue Dividend revenue 39,000 2,200 20,000 800 Total income 41,200 20,800 Cost of sales Other expenses 30,000 5,400 15,000 2,500 Total expenses 35,400 17,500 Gross profit Gain on sale of equipment 5,800 0 3,300 2,400 Profit before income tax 5,700 5,800 1,500 Income tax expense 1,745 Profit for the period Retained earnings (1/7/21) 4,300 7,250 3,955 4,500 11,550 8,455 Interim dividend paid Final dividend declared 2,000 4,000 1,000 1,200 Retained earnings (30/6/22) 5,500 6,255 ONS CU Highlight Erase a B + A Read aloud y Draw Additional information a) On the 1 January 2022, Madari Ltd advanced $50,000 to Concerto Ltd. The interest rate on the advance is 6%p.a payable monthly. b) Madari Ltd records dividend receivable as revenue when dividends are declared. c) The beginning inventories of Concerto Ltd at 1 July 2021 included goods which cost Concerto Ltd $1,000. Concerto Ltd purchased these inventories from Madari Ltd for $1,330 d) Intragroup sales totalled $5,000 for the period ended 30 June 2022. Sales from Madari Ltd to Concerto Ltd, at cost plus 10% mark-up, amounted to $2,800. The ending inventories of Madari Ltd included goods which cost Madari Ltd $2,200. Madari Ltd purchased these inventories from Concerto Ltd at cost plus 10% mark-up. e) On 31 December 2021, Concerto Ltd sold an item of equipment to Madari Ltd for $15,000. This equipment originally cost Concerto Ltd $15,000 but at the time of the intragroup sale it had a carrying amount of $12,600. Madari Ltd depreciates the equipment at the rate of 10% p.a. on cost. Concerto depreciated the equipment at 8% p.a. on cost. The sales revenue account for Madari Ltd includes $3,000 earned from professional services provided to Concerto Ltd in the year ended 30 June 2022. g) The income tax rate is 30%. ii. Required i. Prepare the acquisition analysis at 1 July 2020. ii. Prepare the business combination valuation entries and pre-acquisition entries at 30 June 2021. Prepare the business combination valuation entries and pre-acquisition entries at 30 June 2022 iv. Prepare the consolidation worksheet journal entries to eliminate the effects of intragroup transactions at 30 June 2022. Prepare the consolidation worksheet (in an Excel Spreadsheet) for the preparation of the consolidated statement of financial performance for the year ended 30 June 2022. Totals in your Excel spreadsheet should be calculated using functions. vi. Using the consolidated worksheet, prepare the consolidated statement of profit or loss and other comprehensive income for the period ended 30 June 2022 within Excel. V