Consolidation worksheet, consolidated financialstatements

On 1 July 2018, Ghostbusters Ltd acquired all the sharesof Bat Ltd for $305 000 on an ex-div. basis. On this date,the equity and liabilities of Bat Ltd included the followingbalances:

At acquisition date, all the identifiable assets andliabilities of Bat Ltd were recorded at

amounts equal to fair value except for:

Goodwill was not impaired in any period. The plant andequipment had a further 5-year life at acquisition date and wasexpected to be used evenly over that time. The trademark wasconsidered to have an indefinite life. The machinery, which wasestimated to have a further 4-year life at acquisition date, wassold on 1 January 2020. Any adjustments for differences betweencarrying amounts at acquisition date and fair values are made onconsolidation.

During the year ended 30 June 2019, all inventories onhand at acquisition date were sold, and the land was sold on 1 June2020. Any valuation reserves created are transferred onconsolidation to retained earnings when assets are sold or fullyconsumed.

Additional information

Of the interim dividend paid by Bat Ltd in the currentyear, $5000 was from profits before acquisition date. All otherdividends were from current year profits. Shareholder approval isnot required in relation to dividends.

On 1 July 2019, Bat Ltd has on hand inventory worth $12000, being transferred from Ghostbusters Ltd in June 2019. Theinventory had previously cost Ghostbusters Ltd $8000. On 31 March2020, Bat Ltd transferred an item of plant with a carrying amountof $10 000 to Ghost Ltd for $15 000. Ghostbusters Ltd treated thisitem as inventory. The item was still on hand at the end of theyear. Bat Ltd applied a 20% depreciation rate to thisplant.

On 1 January 2020, Bat Ltd acquired $8000 inventory fromGhostbusters Ltd. This inventory originally cost Ghostbusters Ltd$5000. The profit in inventory on hand at 30 June 2020 was$1000.

During the year ending 30 June 2020, Bat Ltd soldinventory costing $12 000 to Ghostbusters Ltd for $18 000.Two-thirds of this was sold to external parties for$9000.

On 1 January 2019, Ghostbusters Ltd sold furniture toBat Ltd for $8000. This had originally cost Ghostbusters Ltd $12000 and had a carrying amount at the time of sale of $7000. Bothentities charge depreciation at a rate of 10% p.a.

Ghostbusters Ltd sold some land to Bat Ltd in December2019. The land had originally cost Ghostbusters Ltd $25 000, butwas sold to Bat Ltd for only $20 000. To help Bat Ltd pay for theland, Ghostbusters Ltd gave Bat Ltd an interest-free loan of $12000. Bat Ltd has as yet made no repayments on theloan.

The tax rate is 30%.

On 30 June 2020 the trialbalances of Ghostbusters Ltd (Ghost) and Bat Ltd were asfollows:

Required

Prepare the consolidation journal / worksheet entriesfor Ghostbusters Ltd for 30/6/2020.

Update and complete the consolidation worksheet for30/6/2020. Use the worksheet provided below

Financial Statements	Ghost Ltd	Bat Ltd	Adjustments				Group
				Dr	Cr
Sales revenue	220 000	182 000
Other income	62 000	20 000
	282 000	202 000
Cost of sales	162 000	128 000
Other expenses	53 000	41 000
	215 000	169 000
Trading profit	67 000	33 000
Gains/losses on sale of non-current assets	22 000	25 000
Profit before tax	89 000	58 000
Tax expense	20 000	18 000
Profit	69 000	40 000
Retained earnings (1/7/19)	30 000	45 000
Transfer from BCV reserve	0	0
	99 000	85 000
Dividend paid	12 000	10 000
Dividend declared	6 000	4 000
	18 000	14 000
Retained earnings (30/6/20)	81 000	71 000
Share capital	312 000	200 000
General reserve	20 000	25 000
BCVR	-	-
Total Equity	413 000	296 000
Deferred tax liabilities	-	-
Dividend payable	6 000	4 000
Current tax liability	8 000	2 500
Loan from Ghost Ltd	-	12 000
Provisions	78 000	169 500
Total Liabilities	92 000	188 000
Total Liabilities + Equity	505 000	484 000