Parent acquired Subsidiary on January 1, 2020 at a price $450,000 in excess of book value. Of that excess, $350,000 was allocated to an unrecorded patent with a 10-year life, with the remainder to goodwill. The Subsidiarys retained earnings balance on the date of acquisition was $1,379,650. The Parent uses the cost method to account for its investment in the Subsidiary. In 2021, Subsidiary sold to Parent land having a book value of $90,000 for a total price of $244,000. Financial statements of the two companies for the year ended December 31, 2022 are presented below.

Accounts		Parent	Subsidiary
Sales Revenue		7,500,000.00	2,450,000.00
Cost of Goods Sold		(5,930,000.00)	(1,950,000.00)
Gross Profit		1,570,000.00	500,000.00
Operating Expenses		(1,375,000.00)	(286,000.00)
Income (loss) from Subsidiary		176,000.00	-
Net Income		371,000.00	214,000.00
Retained Earnings, 1/1/22		4,045,000.00	1,750,000.00
Net Income		371,000.00	214,000.00
Dividends		(85,000.00)	(176,000.00)
Retained Earnings, 12/31/22		4,331,000.00	1,788,000.00
Cash & Receivables		1,750,000.00	1,145,600.00
Inventory		958,000.00	758,000.00
Investment in Subsidiary		2,412,150.00	-
PP&E (Net)		4,713,850.00	1,116,590.00
Total Assets		9,834,000.00	3,020,190.00
Accounts Payable		980,000.00	225,000.00
Accrued Liabilities		142,800.00	376,500.00
Notes Payable		1,010,200.00	51,190.00
Common Stock		1,792,000.00	158,000.00
Additional Paid-In Capital		1,578,000.00	421,500.00
Retained Earnings, 12/31/22		4,331,000.00	1,788,000.00
Total Liabilities & Equities		9,834,000.00	3,020,190.00

Prepare a consolidated spreadsheet.