Please completely per Excel Worksheet. Use ONLY Microsoft Excel for your calculations.

P 5-7 Consolidation workpapers (upstream sales, noncontrolling interest) Pal Corporation purchased a 90 percent interest in Sal Corporation on December 31, 2010, for $2,700,000 cash, when Sal had capital stock of $2,000,000 and retained earnings of $500,000. All Sal's assets and liabilities were recorded at fair values when Pal acquired its interest. The excess of fair value over book value is due to previously unrecorded patents and is being amortized over a 10-year period. The Pal-Sal affiliation is a vertically integrated merchandising operation, with Sal selling all of its output to Pal Corporation at 140 percent of its cost. Pal sells the merchandise acquired from Sal at 150 percent of its purchase price from Sal. All of Pal's December 31, 2011, and Decem- ber 31, 2012, inventories of $280,000 and $420,000, respectively, were acquired from Sal. Sal's December 31, 2011, and December 31, 2012, inventories were $800,000 each. Pal's accounts payable at December 31, 2012, includes $100,000 owed to Sal from 2012 purchases. Comparative financial statements for Pal Corporation and Sal Corporation at and for the year ended December 31, 2012, are as follows (in thousands): Pal Sal Combined Income and Retained Earnings Statement for the Year Ended December 31, 2012 Sales $8,190 $5,600 Income from Sal 819 Cost of sales (5,460) (4,000) Other expenses (1,544) (600) Net income 2,005 Add: Beginning retained earnings 1.200 Deduct: Dividends (1,000) (500) Retained earnings December 31, 2012 $2,205 $1,200 Balance Sheet at December 31, 2012 Cash $ 753 $ 500 Inventory 420 Other current assets Plant assets-net 3,000 3,000 Investment in Sal 3,132 Total assets $7,905 $4,500 Current liabilities $1,700 $1,300 Capital stock 4,000 2,000 Retained earnings 2.205 1,200 Total equities $7,905 $4,500 1.000 700 800 200 600 Intercompany Profit Transactions-Inventories 177 REQUIRED: Prepare consolidation workpapers for Pal Corporation and Subsidiary for the year ended December 31, 2012. NAME HERE P 5-7 POL CORPORATION AND SUBSIDIARY CONSOLIDATION WORKSHEET FOR THE YEAR ENDED DECEMBER 31, 2012 90% Adjustments & Elimination Pol San Debits Credits Consolidated Statements INCOME STATEMENT Sales Income from San Cost of sales 5,600.0 8,190.0 819.0 (5.460.0) 13,790.0 819.0 (9.460.0) (4,000.0) (1,544.0) (600.0) (2.144.0) 3,005.0 0.0 3,005.0 2,005.0 1,000.0 Other expenses Consolidated NI Noncontrolling int. share Controlling share RETAINED EARNINGS Retained earnings beg Controlling share Dividends 1,200.0 | 2,005.0 (1,000.0) 700.0 1,000.0 (500.0) 1,900.0 3,005.0 (1,500.0) 2,205.0 1,200.0 3,405.0 Retained earnings end BALANCE SHEET Cash Inventory Other current assets Plant assets-net Investment in San 753.0 420.0 600.0 3,000.0 3,132.0 500.0 800.0 200.0 3,000.0 I 1,253.0 1,220.0 800.0 6,000.0 3.132.0 I Patents Total assets Current liabilities Capital stock Retained earnings Total equities Noncontrollong interest 7,905.0 1,700.0 4,000.0 2.205.0 7,905.0 4,500.0 1,300.0 2,000.0 1,200.0 4,500.0 0.0 12,405.0 3,000.0 6,000.0 3,405.0 0.0 12,405.0 0.0 0.0