Create a December 31, 2011 three-part consolidation Excel spreadsheet workpaper based on the information given below Your spreadsheet should be similar to Figure 5-7 p 218 of our 9thediion textbook for your consolidation workpaper excel spreadsheet, you should Prepare necessary December 31.2011 eliminating entries, separate from the worksheet B include all necessary support work for your eliminating entry amounts Determine any goodwill or gain on acquisition and any identifiable net asset differentials related to the original acquisition and any identifiable net asset differentials related to the original acquisition of Schwinn common stock determine the missing amounts from the given trial create the appropriate columns and rows in the consolidation workpaper import trial balance data pulled from the given trial balances, do NOT copy numbers create appropriate formulas for any numerical calculations do NOT copy totals from other sources import the eliminating entry data into the worksheet, do NOT copy numbers with references to the eliminating entry from which the data was imported create appropriate formulas for the balances in the consolidation column Assessment; 1/2 based on Excel skills & 112 on correct consolidation process with documentation you will be assessed on the following items: correct data entered data and headings are accurate and located in the appropriate cells. data is entered correctly formulas are correct and accessible autosum, appropriate use of parenthesis, and other functions are correct all the formulas used are applied correctly column headings and labels column headings are formatted in bold all the data is formatted correctly, including applying bold to the appropriate headings and label titles are merged and centered titles are merged centered, underlined, and bold spreadsheet formatting and printing correct print area and print features showing reveal formulas functions used column widths allow for complete viewing of the contents Pinarello Inc buys 70% of show inn Inc common stock on January 1, 2011 for $520,000 The fair value of show inn net assets equal the book values except for inventory with a fair value $30,000 more than book value inventory costs are recorded a FIFO basis Equipment with a fair values $110,000 more than book value equipment has a remaining life of 10 years The noncontrolling interest in the fair value of net assets = $222,000