Parker Company acquired 80% ownership of Noah Company on Jan. 1, 2020 for $200,000. On that date, the fair value of the NCI was $50,000, and Noah reported retained earnings of $50,000 and had $100,000 of common stock outstanding. On the data of combination, the fair value of Noah's building was $50,000 more than book value, with 10 year remaining useful life. While the fair value of Noah's equipment was $5,000 less than the book value, with 5 year remaining useful life. Parker uses the equity method in accounting for its investment in Noah.

The following account balances are for the year ending December 31, 2020 for both companies

	Parker Corporation	Noah Company
Sales revenue	200,000	100,000
Cost of goods sold	(120,000)	(50,000)
Depreciation Expense	(25,000)	(15,000)
Salaries and wages expense	(15,800)	(5,000)
Income from Nic Company	20,800
Consolidated Net Income	60,000	30,000
Beginning Balance	314,000	90,000
Net Income	60,000	30,000
Less: Dividends Declared	(30,000)	(10,000)
Ending Balance	344,000	110,000
Cash and Receivables	81,000	65,000
Inventory	152,800	20,000
Land	80,000	30,000
Equipment, net	60,000	60,000
Buildings, net	295,000	105,000
Investment in Nic Company	235,200
Total Assets	904,000	280,000
Accounts Payable	60,000	20,000
Notes Payable	200,000	50,000
Common Stock	300,000	100,000
Retained Earnings	344,000	110,000
Total liabilities and stockholders' equity	904,000	280,000

1.) Requirments: Prepare a consolidation worksheet for this business combination that includes a separate column for NCI