Hi everyone

Can somebody help me with this exercise?

I really appreciate it.

all the best!

thank you so much.

On 1 July 2018, Joel Ltd acquired all the shares of Billy Ltd for $425 000 on an ex-div. basis. On this date, the equity and liabilities of Billy Ltd included the following balances: Share capital General reserve Retained earnings Dividend Payable $100,000 25,000 145,000 8,000 U At acquisition date, all the identifiable assets and liabilities of Billy Ltd were recorded at amounts equal to fair value except for: Carrying amount $400,000 Fair value $404,000 Plant and equipment (cost $500,000) Patent Inventories Land Machinery (cost $120,000) 200,000 30,000 50,000 90,000 210,000 40,000 70,000 91,000 The plant and equipment had a useful life of 5 years at acquisition date and was expected to be used evenly over that time. The patent was considered to have an indefinite life. The machinery had a further 4-year useful life at acquisition date. Any adjustments for differences between carrying amounts at acquisition date and fair values are made on consolidation. During the year ended 30 June 2019, all inventories on hand at acquisition date were sold, and the land was sold on 1 June 2020. Any valuation reserves created are transferred on consolidation to retained earnings when assets are sold or fully consumed. Additional information (a) On 1 July 2019, Billy Ltd has on hand inventory worth $24 000, being transferred from Joel Ltd in June 2019. The inventory had previously cost Joel Ltd $20 000. (b) On 30 April 2020, Billy Ltd transferred an item of plant with a carrying amount of $65 000 to Joel Ltd for $85 000. Joel Ltd treated this item as inventory. The item was still on hand at the end of the year. Billy Ltd applied a 20% depreciation rate to this plant. (c) On 1 March 2020, Billy Ltd acquired $9 000 inventory from Joel Ltd. This inventory originally cost Joel Ltd $5000. 75% of this inventory has been sold to external parties for $15,000. (d) On 1 January 2019, Joel Ltd sold furniture to Billy Ltd for $18,000. This furniture had originally cost Joel Ltd $22 000 and had a carrying amount at the time of sale of $17,000. Both entities charge depreciation at a rate of 20% p.a. (e) Joel Ltd sold some land to Billy Ltd in 31 December 2019. The land had originally cost Joel Ltd $85 000, but was sold to Billy Ltd for only $80 000. To help Billy Ltd pay for the land, Joel Ltd gave Billy Ltd a loan of $326 000. Billy Ltd has not made any repayments on the loan. Interest is charged at 15% on the loan and the last interest payment was made on 31 March 2020. The corporate tax rate is 30%. Required: a. Prepare the acquisition analysis as at 1 July 2018 for Joel Ltd. (8 marks) b. Prepare the consolidation worksheet for Joel Ltd as at 30 June 2020, using the attached template. (81 marks) c. Prepare a consolidated statement of financial position using account format, for Joel Ltd as at 30 June 2020. (11 marks) Joel Billy Adjustments Financial Statements as at 30 June 2020 Joel Ltd Group ($) Ltd Ltd Ref Dr ($) Ref Cr ($) Sales revenue 212,000 220,000 Dividend income 62,000 20,000 Interest income 30,000 232,000 312,000 Cost of sales 128,000 162,000 Other expenses 83,000 71,000 Total expenses 199,000 245,000 67,000 Trading profit 33,000 Gains/losses on sale of non-current assets 22,000 25,000 Profit before tax 89,000 58,000 Tax expense 26,700 17,400 Profit after tax 62,300 40,600 Joel Billy Adjustments Financial Statements as at 30 June 2020 Joel Ltd Group ($) Ltd Ltd Ref Dr ($) Ref Cr ($) Retained earnings (1/7/19) 30,000 145,000 Transfer from BCVR reserve Dividend paid 12,000 7,000 6,000 Dividend declared Retained earnings 30/6 14,000 164,600 74,300 Share capital 100,000 312,000 20,000 General reserve 25,000 BCVR Total Equity 406,300 289,600 Deferred tax liabilities Interest Payable Dividend payable 12,225 14,000 20,000 Current tax liability 102,500 322,000 Loan from Joel Ltd 326,000 Accounts Payable 246,900 196,925 Total Liabilities 701,625 538,925 945,225 Total Liabilities + Equity 991,225 Joel Billy Adjustments Financial Statements as at 30 June 2020 Joel Ltd Group ($) Ltd Ltd Ref Dr ($) Ref Cr ($) Shares in Billy Ltd 425,000 7,800 Cash 35,000 Inventory 20,000 50,000 3,000 Dividend Receivable Interest Receivable Accounts Receivable Land 14,000 12,225 6,000 25,000 32,225 50,000 Plant & equipment 500,000 113,000 (34,000) 15,000 (100,000) 120,000 Accumulated depreciation - Plant Machinery Accumulated depreciation - Machine Furniture Accumulated depreciation - Furniture (1,000) 7,000 (30,000) 8,000 (1,000) Patent Goodwill (2,000) 200,000 125,000 Deferred tax assets 10,200 Loan to Billy Ltd 326,000 Total assets 945,225 991,225 On 1 July 2018, Joel Ltd acquired all the shares of Billy Ltd for $425 000 on an ex-div. basis. On this date, the equity and liabilities of Billy Ltd included the following balances: Share capital General reserve Retained earnings Dividend Payable $100,000 25,000 145,000 8,000 U At acquisition date, all the identifiable assets and liabilities of Billy Ltd were recorded at amounts equal to fair value except for: Carrying amount $400,000 Fair value $404,000 Plant and equipment (cost $500,000) Patent Inventories Land Machinery (cost $120,000) 200,000 30,000 50,000 90,000 210,000 40,000 70,000 91,000 The plant and equipment had a useful life of 5 years at acquisition date and was expected to be used evenly over that time. The patent was considered to have an indefinite life. The machinery had a further 4-year useful life at acquisition date. Any adjustments for differences between carrying amounts at acquisition date and fair values are made on consolidation. During the year ended 30 June 2019, all inventories on hand at acquisition date were sold, and the land was sold on 1 June 2020. Any valuation reserves created are transferred on consolidation to retained earnings when assets are sold or fully consumed. Additional information (a) On 1 July 2019, Billy Ltd has on hand inventory worth $24 000, being transferred from Joel Ltd in June 2019. The inventory had previously cost Joel Ltd $20 000. (b) On 30 April 2020, Billy Ltd transferred an item of plant with a carrying amount of $65 000 to Joel Ltd for $85 000. Joel Ltd treated this item as inventory. The item was still on hand at the end of the year. Billy Ltd applied a 20% depreciation rate to this plant. (c) On 1 March 2020, Billy Ltd acquired $9 000 inventory from Joel Ltd. This inventory originally cost Joel Ltd $5000. 75% of this inventory has been sold to external parties for $15,000. (d) On 1 January 2019, Joel Ltd sold furniture to Billy Ltd for $18,000. This furniture had originally cost Joel Ltd $22 000 and had a carrying amount at the time of sale of $17,000. Both entities charge depreciation at a rate of 20% p.a. (e) Joel Ltd sold some land to Billy Ltd in 31 December 2019. The land had originally cost Joel Ltd $85 000, but was sold to Billy Ltd for only $80 000. To help Billy Ltd pay for the land, Joel Ltd gave Billy Ltd a loan of $326 000. Billy Ltd has not made any repayments on the loan. Interest is charged at 15% on the loan and the last interest payment was made on 31 March 2020. The corporate tax rate is 30%. Required: a. Prepare the acquisition analysis as at 1 July 2018 for Joel Ltd. (8 marks) b. Prepare the consolidation worksheet for Joel Ltd as at 30 June 2020, using the attached template. (81 marks) c. Prepare a consolidated statement of financial position using account format, for Joel Ltd as at 30 June 2020. (11 marks) Joel Billy Adjustments Financial Statements as at 30 June 2020 Joel Ltd Group ($) Ltd Ltd Ref Dr ($) Ref Cr ($) Sales revenue 212,000 220,000 Dividend income 62,000 20,000 Interest income 30,000 232,000 312,000 Cost of sales 128,000 162,000 Other expenses 83,000 71,000 Total expenses 199,000 245,000 67,000 Trading profit 33,000 Gains/losses on sale of non-current assets 22,000 25,000 Profit before tax 89,000 58,000 Tax expense 26,700 17,400 Profit after tax 62,300 40,600 Joel Billy Adjustments Financial Statements as at 30 June 2020 Joel Ltd Group ($) Ltd Ltd Ref Dr ($) Ref Cr ($) Retained earnings (1/7/19) 30,000 145,000 Transfer from BCVR reserve Dividend paid 12,000 7,000 6,000 Dividend declared Retained earnings 30/6 14,000 164,600 74,300 Share capital 100,000 312,000 20,000 General reserve 25,000 BCVR Total Equity 406,300 289,600 Deferred tax liabilities Interest Payable Dividend payable 12,225 14,000 20,000 Current tax liability 102,500 322,000 Loan from Joel Ltd 326,000 Accounts Payable 246,900 196,925 Total Liabilities 701,625 538,925 945,225 Total Liabilities + Equity 991,225 Joel Billy Adjustments Financial Statements as at 30 June 2020 Joel Ltd Group ($) Ltd Ltd Ref Dr ($) Ref Cr ($) Shares in Billy Ltd 425,000 7,800 Cash 35,000 Inventory 20,000 50,000 3,000 Dividend Receivable Interest Receivable Accounts Receivable Land 14,000 12,225 6,000 25,000 32,225 50,000 Plant & equipment 500,000 113,000 (34,000) 15,000 (100,000) 120,000 Accumulated depreciation - Plant Machinery Accumulated depreciation - Machine Furniture Accumulated depreciation - Furniture (1,000) 7,000 (30,000) 8,000 (1,000) Patent Goodwill (2,000) 200,000 125,000 Deferred tax assets 10,200 Loan to Billy Ltd 326,000 Total assets 945,225 991,225