100% purchase, goodwill, worksheet. On December 31, 2015, Aron Company purchases 100% of the common stock of Shield Company for $450,000 cash. On this date, any excess of cost over book value is...

100% purchase, goodwill, worksheet. On December 31, 2015, Aron Company purchases 100% of the common stock of Shield Company for $450,000 cash. On this date, any excess of cost over book value is attributed to accounts with fair values that differ from book values. These accounts of Shield Company have the following fair values:

The following comparative balance sheets are prepared for the two companies immediately after the purchase:

1. Prepare the value analysis schedule and the determination and distribution of excess schedule for the investment in Shield Company.

2. Complete a consolidated worksheet for Aron Company and its subsidiary Shield Company as of December 31, 2015.