P acquiredan 80% intrerest inS on 12/31/2010 for $8,600. GW is entirely due to a control premium. P &S use FIFO for inventory and Straight-line deprecaiattion with $0residual value for equipment. Intangible assets are accounted for in accordance with GAAP.Included below are:

Differences between FMV and BV at 12/31/2010, information about intercompany sales of inventory and long-lived assets and GW impairment.

Required:

1. Create a schedule showing adjustments to S's assets@ 12/31/2010 as well as how GW and NCI werecalculated ).

2. Complete the 2010-12consolidations. You must use formulasfor all subtotals and totals whether in the debit and credit column or the consolidated column. . You are not required touse formulas for any other work.Just input debit and credits. Show calculations for GW impairment, and the sale of the equipment and copy right

3. Assuming that SNI = $5,000 in 2013, and dividends = $2,000, prepare schedules for Equity Income, I, NCI INC, NCI.

You may show your work usingpenciland paper or on the spreadsheet. If you choose to use the spreadsheet, the work must be placed in a logical manner (eg. Equipment gain or loss is calculated near theequipment information, 2013 caiculations follow 2012 consolidated statements.