Please prepare using an Excel spreadsheet

1 Prepare the BCVR and pre-acquisition journal entries at 1 July 2013.

2 Prepare the BCVR and pre-acquisition journal entries at 30 June 2017.

ACCT2201 GROUP CASE STUDY On 1 July 2013 Tom Limited acquired all of the share capital of Harry Limited for a consideration of $500,000 cash. At that date all the identifiable assets and liabilities were recorded at fair value with the exception of ASSET Inventory Land Plant (less depn) Book Value 12,000 25,000 45,000 (17000) 28,000 21,000 Market Value 13,000 30,000 35,000 19,000 Acounts Receivable The inventory was all sold by 30/6/14. The remaining useful life of the plant is 7 years The accounts receivable were collected by 30/6/14 for $19,000 The land was sold on 30/12/16 for $32,000. The plant was on hand still at 30/6/17 At the date of acquisition the equity of Harry Ltd consisted of Share Capital General Reserve Retained Earnings 320,000 78,000 65,000 Information from the trial balances of Tom Ltd and Harry Ltd at 30 June 2017 is presented overleaf Additional Information 1. On 1 Jan 2017 Harry Ltd sold inventory to Tom Ltd costing $25,000 for $40,000. Half of this inventory was sold to outside parties for $28,000 by 30/6/17 2. On 1 Jan 2016 Harry Ltd sold inventory costing $8000 to Tom Ltd for $11000. Tom Ltd treats the item as equipment and depreciates it at 5% per annum. 3.On 1 July 2016 Harry sold plant to Tom for $7,000. The plant had cost Harry $8,000 on 1 July 2014 and it was being depreciated at 10% per annum. Tom regards the plant as inventory The inventory was all sold by 30th July 2016. 4. At 1 July 2016 Harry Ltd held inventory that it had purchased from Tom Ltd on 1 June 2016 at a profit of $4000. All inventory was sold by 30 June 2017 5. Tom Ltd accrues dividends from Harry Ltd once they are declared. 6. Tom Ltd has earned $1200 in interest revenue in the 2017 financial year from Harry Ltd. 7. Tom Ltd has earned $2400 in service revenue in the 2017 financial year from Harry Ltd 8, Assume a tax rate of 30%. ACCT2201 GROUP CASE STUDY On 1 July 2013 Tom Limited acquired all of the share capital of Harry Limited for a consideration of $500,000 cash. At that date all the identifiable assets and liabilities were recorded at fair value with the exception of ASSET Inventory Land Plant (less depn) Book Value 12,000 25,000 45,000 (17000) 28,000 21,000 Market Value 13,000 30,000 35,000 19,000 Acounts Receivable The inventory was all sold by 30/6/14. The remaining useful life of the plant is 7 years The accounts receivable were collected by 30/6/14 for $19,000 The land was sold on 30/12/16 for $32,000. The plant was on hand still at 30/6/17 At the date of acquisition the equity of Harry Ltd consisted of Share Capital General Reserve Retained Earnings 320,000 78,000 65,000 Information from the trial balances of Tom Ltd and Harry Ltd at 30 June 2017 is presented overleaf Additional Information 1. On 1 Jan 2017 Harry Ltd sold inventory to Tom Ltd costing $25,000 for $40,000. Half of this inventory was sold to outside parties for $28,000 by 30/6/17 2. On 1 Jan 2016 Harry Ltd sold inventory costing $8000 to Tom Ltd for $11000. Tom Ltd treats the item as equipment and depreciates it at 5% per annum. 3.On 1 July 2016 Harry sold plant to Tom for $7,000. The plant had cost Harry $8,000 on 1 July 2014 and it was being depreciated at 10% per annum. Tom regards the plant as inventory The inventory was all sold by 30th July 2016. 4. At 1 July 2016 Harry Ltd held inventory that it had purchased from Tom Ltd on 1 June 2016 at a profit of $4000. All inventory was sold by 30 June 2017 5. Tom Ltd accrues dividends from Harry Ltd once they are declared. 6. Tom Ltd has earned $1200 in interest revenue in the 2017 financial year from Harry Ltd. 7. Tom Ltd has earned $2400 in service revenue in the 2017 financial year from Harry Ltd 8, Assume a tax rate of 30%