I have attached the description of the problem in a word file and the excel file that I need help inserting the information into.

Assume that Paulcraft pays $480,000 for 100% of Switzer common stock. Paulcraft uses the cost method to account for its investment in Switzer. Paulcraft and Switzer have the following trial balances on December 31, 2017 as shown. Paulcraft Switzer Cash 100,000 110,000 Accounts Receivable 90,000 55,000 Inventory 120,000 86,000 Land 100,000 60,000 Investment in Switzer 480,000 Buildings 800,000 250,000 Accumulated Depreciation (220,000) (80,000) Equipment 150,000 100,000 Accumulated Depreciation (90,000) (72,000) Current Liabilities (60,000) (102,000) Bonds Payable. Common Stock (100,000) (100,000) (10,000) Paulcraft Switzer Paid-In Capital in Excess of Par (900,000) (90,000) Retained Earnings, January 1, 2017 (315,000) (182,000) Sales (800,000) (350,000) Cost of Goods Sold 450,000 210,000 Depreciation ExpenseBuildings 30,000 15,000 Depreciation ExpenseEquipment 15,000 14,000 Other Expenses 140,000 68,000 Interest Expense Dividend Income Dividends Declared Totals 8,000 (10,000) 20,000 10,000 0 0 Required 1. Prepare a value analysis and a determination and distribution of excess schedule for the investment in Switzer. 2. Complete a consolidated worksheet for Paulcraft Corporation and its subsidiary Switzer Corporation as of December 31, 2017. Prepare supporting amortization and income distribution schedules. Name of Company Being Acquired Name of Acquiring Company Date of Acquisition Switzer Corporation Paulcraft Corporation January 1, 2015 Date of Acquisition Book Switzer Corporation Market Life Assets Cash Accounts Receivable Inventory Investment in Subsidiary Land Buildings Accumulated Depreciation Equipment Accumulated Depreciation Goodwill Total Assets - - - - Liabilities Current Liabilities Bonds Payable Discount on Bonds Payable Total Liabilities Equity Acquired Company Common Stock Paid-in Capital in Excess of Par Retained Earnings Equity Acquiring Company Common Stock Paid-in Capital in Excess of Par Retained Earnings Total Equity Total Liabilities and Equity Net Assets at Market of Acquired Co. - Dividends Declared Acquired Company Dividends Declared Acquiring Company Sales Cost of Goods Sold Depreciation Expense of Buildings Equipment Amortization Expense of Other Expenses Interest Expense Subsidiary Income Total Balances Purchase Price Cash Number of shares exchanged Par value of a share of stock Market value of a share of stock Market value of stock exchanged - Total purchase price Ownership Interest enter as .7 for 70% Goodwill Applicable to NCI Implied Value of NCI Interest Estimated Value of NCI interest if not the implied proportional amount--Enter amount or 0 #DIV/0! - Method of Accounting for Investment--Enter Capital C for Cost or Capital E for Equity Years since Acquisition Value Analysis Company Fair Value Fair Value of Net Assets Excluding Goodwill Company Fair Value Parent Price #DIV/0! - NCI Value #DIV/0! - Goodwill Gain on Acquisition #DIV/0! - #DIV/0! #DIV/0! Determination and Distribution of Excess Schedule Implied Company Value Parent Price #DIV/0! Fair Value of Company Less Book Value of Interest Acquired Common Stock Paid-in Capital in Excess of Par Retained Earnings Total Equity - Interest Acquired Book Value Excess of Fair Value over Book Value - - Adjustment to Identifiable Accounts Inventory Debit (Credit) Investment in Subsidiary Gain Taken to Acquiring Co. RE/Income Acquired Company RE #DIV/0! #DIV/0! #DIV/0! Check #DIV/0! Land Buildings Equipment Goodwill Bonds Payable Discount on Bonds Payable - Inventory Buildings Equipment 1.00 #DIV/0! 0 - Elimination Entry Common Stock Paid-in Capital in Excess of Par Retained Earnings Investment in Subsidiary Amortization Schedule Account Adjustment NCI Value #DIV/0! Annual Amount Key EL EL EL EL Key D D D D D D D D D D D D D D D Life Current Year Prior Years - Discount on Bonds Payable Total Amortization Entry Cost of Goods Sold Depreciation Expense of Buildings Equipment 0 Debit (Credit) Key A A A A Amortization Expense of Interest Expense Acquired Company RE Acquiring Company RE Inventory Accumulated Depreciation Accumulated Depreciation - Discount on Bonds Payable Total Method Adjustment Schedule Is Adjustment Necessary? Adjustment to Investment Account Debit (Credit) NO Adjustment to Investment Account under Equity Method Key - CV Adjustment to Retained Earnings Account Date Alignment Schedule Adjustment to Subsidiary Income Account Adjustment to Subsidiary Dividend Account A A A A A A A A A A A A A A A - CV Debit (Credit) Key - CY - CY - CY 0 Current Year Trial Balance Paulcraft Corporatio Switzer Corporation Balances Balances Total