I AM ONLY LOOKING FOR PHASE TWO OF THIS QUESTION

AND THIS IS THE TEMPLATE THAT IS PROVIDED:

Thanks in advance :)

PHASE 1 Al Bruno provides you with the following information: Consolidation accounting policies The consolidated financial statements incorporate the financial statements of the subsidiary (Smashed Limited) of Parts Palace Limited ("Parent") as at the reporting date. Parts Palace Limited and its subsidiary together are referred to in these financial statements as the "Group" or the consolidated entity. The subsidiary is an entity over which the Parent has control. The Parent controls an entity when it is exposed to, or has rights to, variable returns from its involvement with the entity and has the ability to affect those returns through its power over the entity. The subsidiary is included in the consolidated financial statements using the acquisition method of consolidation. It is fully consolidated from the date on which control is transferred to the Parent. The Group recognises non-controlling interest at its proportionate share of subsidiary net identifiable assets. The Subsidiary, Smashed On 31 December 2016, Parts Palace Limited acquired 75% of the shares in Smashed Limited. On that date, the equity of Smashed Limited comprised: $ 000 Share capital 700 Retained earnings 400 Equity $1,100 At acquisition, the book value of the assets and liabilities of Smashed Limited were considered to be at fair value, except for some non-depreciable assets (included under .Other non-current assets and considered to be part of net identifiable assets) that had a book value of zero and where Parts Palace assessed their fair value to be $160,000. There has been no change to assessed value of these assets since acquisition. Goodwill impairment At the most recent balance date (31 December 2019), the returns from Smashed were not as high as expected. The directors of Parts Palace considered that acquired goodwill had been impaired by $250,000. Tax and Deferred Tax Assume a tax rate of 30% wherever relevant i.e., for both Phase 1 and Phase 2). Breakdown of Cost of Sales figures supplied below for 31 December 2019 Parts Palace Smashed Opening inventory Purchases Closing inventory Cost of sales S000S 450 1250 300 1400 S000s 400 550 350 600 Sales Financial statements Income statement for year end 31 December & Balance sheet as at 31 December 2019 Parts Palace $000 4,200 Cost of sales 1,400 Gross profit 2,800 Operating expenses (incl. Interest, Depn & Impairment) 300 Other income (incl. Dividends & Interest) 400 Operating profit before tax 2,900 Income tax 500 Net Profit 2,400 Smashed $000s 1,600 600 1,000 400 100 700 300 400 Opening Retained earnings 1,500 500 3,900 Dividends paid Closing retained earnings 800 3,100 900 200 700 Share capital Total equity 2,200 5,300 2011 700 1,400 Accounts Payable Deferred tax Other non-current liabilities Total liabilities 800 600 700 2,100 200 130 800 1,130 Total liabilities and equity 7,400 2,530 100 200 Cash Accounts Receivable Inventory Current assets 80 100 350 300 600 530 Investment in Smashed (at Cost) Plant (net) Other non-current assets Non-current assets 2,000 3,700 1,100 6,800 1,300 700 2,000 Total assets 7,400 2,530 PHASE 2 Now that you have considered the Phase 1 information and completed the relevant template for Al Bruno's review, he wants you to go on to consider consolidation adjustments for intra-group transactions in more detail. Al wants to ensure you have the basics right before you go on to dealing with the impact of these adjustments on the consolidated financial statements. He tells you that profit on merchandise sales was 80%* for Parts Palace and 90%* for Smashed for all sales transactions including inter-group transactions (* = as a percentage of sales). He has asked you to provide him with a spreadsheet showing the consolidation adjustments in journal form only for the following intra-group transactions during 2019 (all figures below are in $000s): 1. Parts Palace sold Smashed merchandise at a price of $150. 2. Smashed sold Parts Palace merchandise at a price of $250. 3. $35 remained owing by Parts Palace at 31 December 2019 for the merchandise sold to it by Smashed. 4. Parts Palace's inventories included merchandise bought from Smashed of: a. $20 at the beginning of 2019, and b. $30 at the end of 2019. 5. Smashed's 2019 inventories included merchandise bought from Parts Palace of: a. Beginning: $20, and b. Closing: $15. 6. The 'Other non-current assets' on Parts Palace's balance sheet includes a long-term loan to Smashed of $800. 7. The terms of the loan to Smashed require 9% annual interest payments. The loan was made on 1 January 2019 and interest is paid on 31 December each year. Phase 2 Required: Prepare the consolidation journal entries only for the above intragroup transactions for the year ended 31 December 2019. Please use the "Phase 2" tab on the Excel template provided and adhere strictly to the following instructions: a) You will need to choose the most appropriate accounts to which to post each journal adjustment. b) Post a separate numbered journal entry for each numbered piece of information above i.e., your journal entries should be posted to the corresponding columns for the above numbers 1 -7. For example, you will need to post a separate journal entry (Dr and Cr) for #3 and a separate journal entry (Dr and Cr) for #4a. c) You are only required to prepare journal entries for Phase 2 i.e., Al does not want you to adjust the Phase 1 figures until he has reviewed and authorised the journal entries. #1 #2 #3 #4a #4b DR CRDR CRDR CRDR CRDR CRDRCR #5a DR #5b CRDR #6 CRDR CR Accounts (all amounts in $000s): Sales Beginning inventory Purchases Ending inventory Operating expenses (incl. Interest, Dep & Impairment) Other income (incl. Dividends & Interest) Income Tax Non controlling interest in earnings Opening Retained earnings Dividends paid Closing retained earnings Share capital Non-controlling interest Accounts Payable Deferred tax Other non-current liabilities Cash Accounts Receivable Inventory Investment in Smashed (at Cost) Plant (net) Goodwill Other non-current assets PHASE 1 Al Bruno provides you with the following information: Consolidation accounting policies The consolidated financial statements incorporate the financial statements of the subsidiary (Smashed Limited) of Parts Palace Limited ("Parent") as at the reporting date. Parts Palace Limited and its subsidiary together are referred to in these financial statements as the "Group" or the consolidated entity. The subsidiary is an entity over which the Parent has control. The Parent controls an entity when it is exposed to, or has rights to, variable returns from its involvement with the entity and has the ability to affect those returns through its power over the entity. The subsidiary is included in the consolidated financial statements using the acquisition method of consolidation. It is fully consolidated from the date on which control is transferred to the Parent. The Group recognises non-controlling interest at its proportionate share of subsidiary net identifiable assets. The Subsidiary, Smashed On 31 December 2016, Parts Palace Limited acquired 75% of the shares in Smashed Limited. On that date, the equity of Smashed Limited comprised: $ 000 Share capital 700 Retained earnings 400 Equity $1,100 At acquisition, the book value of the assets and liabilities of Smashed Limited were considered to be at fair value, except for some non-depreciable assets (included under .Other non-current assets and considered to be part of net identifiable assets) that had a book value of zero and where Parts Palace assessed their fair value to be $160,000. There has been no change to assessed value of these assets since acquisition. Goodwill impairment At the most recent balance date (31 December 2019), the returns from Smashed were not as high as expected. The directors of Parts Palace considered that acquired goodwill had been impaired by $250,000. Tax and Deferred Tax Assume a tax rate of 30% wherever relevant i.e., for both Phase 1 and Phase 2). Breakdown of Cost of Sales figures supplied below for 31 December 2019 Parts Palace Smashed Opening inventory Purchases Closing inventory Cost of sales S000S 450 1250 300 1400 S000s 400 550 350 600 Sales Financial statements Income statement for year end 31 December & Balance sheet as at 31 December 2019 Parts Palace $000 4,200 Cost of sales 1,400 Gross profit 2,800 Operating expenses (incl. Interest, Depn & Impairment) 300 Other income (incl. Dividends & Interest) 400 Operating profit before tax 2,900 Income tax 500 Net Profit 2,400 Smashed $000s 1,600 600 1,000 400 100 700 300 400 Opening Retained earnings 1,500 500 3,900 Dividends paid Closing retained earnings 800 3,100 900 200 700 Share capital Total equity 2,200 5,300 2011 700 1,400 Accounts Payable Deferred tax Other non-current liabilities Total liabilities 800 600 700 2,100 200 130 800 1,130 Total liabilities and equity 7,400 2,530 100 200 Cash Accounts Receivable Inventory Current assets 80 100 350 300 600 530 Investment in Smashed (at Cost) Plant (net) Other non-current assets Non-current assets 2,000 3,700 1,100 6,800 1,300 700 2,000 Total assets 7,400 2,530 PHASE 2 Now that you have considered the Phase 1 information and completed the relevant template for Al Bruno's review, he wants you to go on to consider consolidation adjustments for intra-group transactions in more detail. Al wants to ensure you have the basics right before you go on to dealing with the impact of these adjustments on the consolidated financial statements. He tells you that profit on merchandise sales was 80%* for Parts Palace and 90%* for Smashed for all sales transactions including inter-group transactions (* = as a percentage of sales). He has asked you to provide him with a spreadsheet showing the consolidation adjustments in journal form only for the following intra-group transactions during 2019 (all figures below are in $000s): 1. Parts Palace sold Smashed merchandise at a price of $150. 2. Smashed sold Parts Palace merchandise at a price of $250. 3. $35 remained owing by Parts Palace at 31 December 2019 for the merchandise sold to it by Smashed. 4. Parts Palace's inventories included merchandise bought from Smashed of: a. $20 at the beginning of 2019, and b. $30 at the end of 2019. 5. Smashed's 2019 inventories included merchandise bought from Parts Palace of: a. Beginning: $20, and b. Closing: $15. 6. The 'Other non-current assets' on Parts Palace's balance sheet includes a long-term loan to Smashed of $800. 7. The terms of the loan to Smashed require 9% annual interest payments. The loan was made on 1 January 2019 and interest is paid on 31 December each year. Phase 2 Required: Prepare the consolidation journal entries only for the above intragroup transactions for the year ended 31 December 2019. Please use the "Phase 2" tab on the Excel template provided and adhere strictly to the following instructions: a) You will need to choose the most appropriate accounts to which to post each journal adjustment. b) Post a separate numbered journal entry for each numbered piece of information above i.e., your journal entries should be posted to the corresponding columns for the above numbers 1 -7. For example, you will need to post a separate journal entry (Dr and Cr) for #3 and a separate journal entry (Dr and Cr) for #4a. c) You are only required to prepare journal entries for Phase 2 i.e., Al does not want you to adjust the Phase 1 figures until he has reviewed and authorised the journal entries. #1 #2 #3 #4a #4b DR CRDR CRDR CRDR CRDR CRDRCR #5a DR #5b CRDR #6 CRDR CR Accounts (all amounts in $000s): Sales Beginning inventory Purchases Ending inventory Operating expenses (incl. Interest, Dep & Impairment) Other income (incl. Dividends & Interest) Income Tax Non controlling interest in earnings Opening Retained earnings Dividends paid Closing retained earnings Share capital Non-controlling interest Accounts Payable Deferred tax Other non-current liabilities Cash Accounts Receivable Inventory Investment in Smashed (at Cost) Plant (net) Goodwill Other non-current assets