On January 1, 2019, Pace Company issued common stock with a fair value of $1,000,000 plus paid cash of $1,280,000 for 60% of Setter Corporation’s outstanding common stock. At that date, the fair value of Setter’s noncontrolling interest was $1,520,000 and Setter’s book value of net assets was $3,400,000. Setter had developed a customer list that was not recorded on its books but had an acquisition-date fair value of $200,000. At the date of acquisition, the customer list was expected to have a life of 20 years. The buildings and equipment were considered to be undervalued by $120,000 and to have a 15 year remaining life. All of those assets are still in operation at the end of 2020. Notes payable owed by Setter have a maturity date of December 31, 2026, and had a market value on January 1, 2019, of $1,200,000 ($40,000 less than their carrying amount of $1,240,000). On February 15, 2019, Pace sold to Setter land with a book value of $240,000 for $400,000. Setter still owns the land at the end of 2020. For many years, Setter had supplied its patented dog, used for veterinary practitioners’ training sets, to Pace for use in Paces’ medical product line. The companies expect to achieve synergies with production scheduling and product development through this business combination. In 2019, Setter shipped inventory costing $400,000 to Pace for $600,000; in 2020, the intercompany sales rose to $800,000 for goods costing $560,000. At year-end 2019, $120,000 of the goods were still in Pace’s inventory; at year-end 2020, $160,000 of the goods from 2020 intercompany sales were still in Pace’s inventory. Pace owes Setter $80,000 at the end of 2020. Required: Using the above information and the trial balances on the next page, prepare an Excel spreadsheet workbook containing the following in 5 tabs. Save the file using the naming convention LastName_FirstInitial_StudentID_THExamS20.xlsx Submit your solution as an attachment to the Sakai assignment by Wednesday, April 8, 10 a.m. 1. Analysis of the investment by Pace Co. in Setter Corp. at January 1, 2019. 2. Equity method entries to account for the investment for the year 2020. Use cell referencing from the analysis of the investment when appropriate. 3. Consolidation entries in journal entry format for the year 2020. Again cross reference to the analysis of the investment when appropriate. 4. Consolidation worksheet for the year 2020. Be sure to cross reference from the consolidation entries into the worksheet. 5. A classified balance sheet at December 31, 2020 and a multi-step income statement for the year ended December 31, 2020 in good form. Be sure to cross reference from the consolidation worksheet to the financial statements. Pace Company and Setter Corp. Separate Company Trial Balances 31-Dec-20 Pace Setter Sales $ (3,200,000) $ (2,000,000) Cost of Goods Sold 2,000,000 1,200,000 Operating Expenses Selling, General & Administrative 195,800 110,000 Depreciation & Amortization 130,400 80,000 Interest Expense 55,200 50,000 Equity in Earnings of Stork (317,400) Net Income $ (1,136,000) $ (560,000) Retained Earnings, January 1 (4,464,000) (2,480,000) Net Income (1,136,000) (560,000) Dividends Declared and Paid 460,000 240,000 Retained Earnings, December 31 $ (5,140,000) $ (2,800,000) Cash $ 924,400 $ 360,000 Accounts Receivable 1,424,000 1,640,000 Inventory 1,760,000 1,280,000 Investment in Stork 2,687,600 - Land 720,000 1,560,000 Buildings and Equipment (net) 1,984,000 1,200,000 Total Assets $ 9,500,000 $ 6,040,000 Liabilities Accounts Payable $ (480,000) $ (360,000) Long Term Notes Payable (1,440,000) (1,240,000) Stockholders' Equity Common Stock (2,440,000) (1,280,000) Additional Paid-In Capital - (360,000) Retained Earnings (5,140,000) (2,800,000) Total Liabilities and Stockholders' Equity $ (9,500,000) $ (6,040,000)