Consolidation worksheet

Huma Ltd purchased 100% of the outstanding ordinary shares of Sima Ltd on 31 December, 2013 at a cost of $196,000. At that date the Share Capital of Sima Ltd was $50,000. The Retained Profits were $86,000. Payment was made in cash $196,000.

The fair market value of the fixed assets of Sima Ltd. was $160,000, the cost was $140,000 and the accumulated depreciation was $40,000. Other assets in the accounts of Sima Ltd. had a fair value equal to the carrying amount. Fixed Assets in both companies are depreciated over 10 years straight line.

Consolidation worksheet for 31 December 2014
	Huma Ltd	Sima Ltd	Dr	Ref	Cr	Group
Sales	300,000 cr	100,000 cr
Cost of Sales	200,000 dr	40,000 dr
General Expenses	50,000 dr	20,000 dr
Depreciation	30,000 dr	14,000 dr
Tax Expense	6,000 dr	7,800 dr
Dividend Income	5,000 cr	--
Dividend Accrued/expensed	10,000 dr	5,000 dr
Retained Profits for the year 2014	9,000 cr	13,200 cr
Fixed Assets	300,000 dr	140,000 dr
Accumulated Depreciation	130,000 cr	54,000 cr
Investment in Sima Ltd	196,000 dr	--
Goodwill	--	--
Inventory	55,000 dr	20,000 dr
Current Assets	--	6,000 dr
Account Receivable Sima Ltd.	25,000 dr	--
Dividend Receivable	5,000 dr	--
Cash	54,000 dr	67,200 dr
	505,000	179,200
Account Payable - Huma Ltd.	--	25,000 cr
Deferred Tax Liability	--	--
Dividend Payable	10,000 cr	5,000 cr
Share Capital	100,000 cr	50,000 cr
Asset Revaluation Reserve	--	--
Opening Retained Profits (1 Jan. 2014)	386,000 cr	86,000 cr
Retained Profits for the year 2014	9,000 cr	13,200 cr
	505,000	179,200

Required:

Complete the consolidation worksheet at 31 December, 2014. Assets are to be revalued in the accounts of the group, not in the subsidiary. Goodwill is not impaired. The rate of taxation is 30%.

Please help me to complete this table above.