Rule Ltd acquired all the issued capital of Book Ltd on 1 July 2020 for $1,500,000. At that date the shareholders' equity of Book Ltd was:

Share Capital $1,100,000

Retained Earnings $300,000

Additional information for the year ended 30 June 2021:

Inter-company sales:

Rule Ltd to Book Ltd $11,000

Book Ltd to Rule Ltd $19,000

Unrealised profits in closing inventory as at 30 June 2021 is $2,400 for goods sold by Book Ltd to Rule Ltd and $1,200 for goods sold by Rule Ltd to Book Ltd.

Unrealised profit in opening inventory for goods sold by Rule Ltd to Book Ltd as at 1 July 2020 is $2,100 and for goods sold by Book to Rule is $1,400.

Rule Ltd employees provide legal advice to Book Ltd. For these services, Book Ltd pays an annual fee of $8,000 per annum.

The final dividend of $16,500, declared as at 30 June 2020, was paid by Book Ltd in October 2020.

An interim dividend of $14,000 was paid on 31 January and a final dividend was declared $20,000 at 30 June, 2021.

On 30 June 2021, Rule Ltd purchased a motor vehicle from Book Ltd for $15,000. Book Ltd made profit on this sale of $3,500.

Book Ltd raised funds from Rule Ltd by borrowing $100,000 at an interest rate of 10% per annum. The annual interest charge was paid by Book Ltd on 30 June 2021.

The directors review the balance of goodwill each year. They agree that for the year ended 30 June 2021, goodwill is to be unpaired by $20,000.

Required:

Need general journals and the Consolidation worksheet provided in Microsoft Excel