(information for question) Today's fictional case takes place entirely on January 1, 2014. Congratulations! You have been hired by the accounting department of Palmer Company as the Accounting Manager overseeing Financial Reporting. Today is a very exciting day to join the team as Palmer is closing a deal that will result in the acquisition of a 90% controlling interest in Stevens Company through a cash payment of $1,000,000. You have been hired specifically because of this transaction, due to your expertise in Consolidation Accounting. - Stevens Company Date of Acquisition - January 1, 2014 [Subsidiary General Ledger = BLUE) Stevens Company Balance Sheet As of January 1, 2014 Book Value Cash 130,726 Accounts receivable 200,000 Inventories 160,000 Equipment 300,000 Accumulated depreciation (100,000) Land 190,000 Other 54,830 Total assets 935,556 Fair Value 130,726 200,000 210,000 390,000 (130,000) 290,000 54,830 40,000 150,000 Note payable Bonds payable Common stock Retained earnings Total liabilities and equity 40,000 205,556 500,000 190,000 935,556 Palmer Company Date of Acquisition - January 1, 2014 [Parent General Ledger = YELLOW] Cash Accounts receivable Note receivable Inventory Advance to s Equipment Accumulated depreciation Land Total Book Value 1,179,300 187,600 40,000 130,400 35,000 450,000 (250,000) 160,000 1,932,300 Accounts payable Common stock Other contributed capital Retained earnings Total 270,500 400,000 1,000,000 261,800 1,932,300 Trial Balance of Stevens on January 1, 2014 Fair Values of Stevens assets and liabilities on January 1, 2014 Trial Balance of Palmer on January 1, 2014 Additionally, your department has noted the following transactions of interest between Palmer and Stevens: 1. Stevens Company's accounts receivable include $20,000 due from Palmer Company, 2. Stevens Company's $40,000 note payable is payable to Palmer Company 3. Stevens Company has not yet recorded the $35,000 cash advance from Palmer Company. (QUESTION) A completed consolidation worksheet. M N 0 C DE 1 Consolidation Worksheet [Outside of General Ledger System - ORANGE) 1 (Data pulled from Parent General Ledger YELLOW Data pulled from Subsidiary General Ledger BLUE Check: 1 Do the Parent body balance sheets com and 2. Domination dette the credits and coded) med rem 7 PARENT COMPANY AND SUBSIDIARY Consolidated Balance Sheet Workpaper January 1, 2014 Subdiary Company Elmond CE ON Consondated talanca 10 Perent 11 Company 1 Cash 1 Accounts Receivable 14 Not Receivable 15 inwentary 16 Advance to Subsidiary Company 17 Investment in Subsidiary Company 1 Equipment 10 Accumulated depreciation 20 Land 21 Other 22 2 24 Total Assets Accounts Payable 27 Notes Payable 21 Bonds Payable Common Stock 31 Parent Company Subsidiary Company Other Cotabat.Cantal Parent Company 35 Subsidiary Company 36 Retained Earings Purent Company Subsidiary Company Norcontrolling interest 45 Totallisties and Equty