Purple and Sunshine had the following trial balances on December 31, 2016 Purple Rain T 24 000 Accounts receivable nontory Investment in Sandin 30,000 120 000 100 000 512,000 800 000 220.000 150.000 (90,000) 200 000 Accumulated depreciation - bags Accumulated depreciation - equip 72.000 (46.000) Good (00,000) (102.000) (100.000) (10,000) (90,000) (142,000) (100.000) Accounts payable Bond payable Common stock -Sandin Paid in capital in excess of par - Sandin Sandin Retained earnings - Sandin Common stock - Panther Paid in capital in excess of par -Panther Retained earnings-Panther Sales Cost of goods sold Depr. expense -building Depr expense - equipment Other expenses (800,000) (365,000) (800,000) 450,000 30,000 15,000 160,000 (350,000) 208,500 7,500 B000 98.000 8.000 Interest expense Gain on fixed asset sale (20,000) (16,000) Subsidiary income Dividends declared - Sandin Dividends declared - Panther Totals 10,000 20,000 a. Prepare a value analysis and determination of distribution of excess schedule for the investment in Sunshine on January 1, 2015. b. Write out the elimination entries for the December 31, 2016 consolidation. C. Complete the consolidated worksheet as of December 31, 2016. ution of Encess of asso V diary interest Common Stock erest Acquired Excess of Cost over Bock Account Adjusted Distribution Amorturation Schedule Account Adjusted Amount Current Year Prior Years Total Total Amortirations Parent Sub Intercompany Inventory Profit Deferral Parent Amount Beginning Ending Parent Profit Amount Sub Intercompany fixed asset profit deferral Parent Original profit Year of sale Realized in prior years Balance, start of year Reatred in Current year 2. On january 1, 2015, Panther Company acquired Sunshine Company, Purple Rain Company paid $60 per share for Box of Sunshine's common stock. The price paid by Purple reflected a control premium. The NCI shares were estimated to have a market value of $55 per share. On the date of acquisition, Sunshine had the following balance sheet: Sunshine Company lance Sheet 1-Jan-15 Assets Accounts Receivable Inventory $ Liabilities and Equity Accounts Payable $ 40.000 Bonds Payable 100 000 Common Stock Sipari 10.000 Paid in excess of par 90.000 Retained Earnings 112.000 60,000 0.000 60,000 200.000 (S0,000 72.000 (30,000) Buildings Accumulated Depreciation Equipment Accumulated Depreciation Total Assets $ 353,000 $ 352,000 Buildings, which have a 20-year life, were understated by $120,000. Equipment, which has a 50year life was understated by $40,000. Any remaining excess was considered goodwill. Purple used the simple equity method to account for its investment in Sunshine. January 1, 2016, Purple held merchandise sold to it from Sunshine for $12,000. This beginning inventory had an applicable gross profit of 20%. During 2016, Sunshine sold merchandise to Purple for $90,000. On December 31, 2016, Purple held $18,000 of this merchandise in its inventory (applicable gross profit rate of 25%). Purple owed Sunshine $20,000 on December 31 as a result of this intercompany sale. On January 1, 2016, Purple sold equipment with a book value of $35,000 to Sunshine $45,000. Purple also sold assets to nonaffiliates. During 2016, the equipment was used by Sunshine. Depreciation is computed over a 5-year life, using the straight-line method. Purple and Sunshine had the following trial balances on December 31, 2016 Purple Rain T 24 000 Accounts receivable nontory Investment in Sandin 30,000 120 000 100 000 512,000 800 000 220.000 150.000 (90,000) 200 000 Accumulated depreciation - bags Accumulated depreciation - equip 72.000 (46.000) Good (00,000) (102.000) (100.000) (10,000) (90,000) (142,000) (100.000) Accounts payable Bond payable Common stock -Sandin Paid in capital in excess of par - Sandin Sandin Retained earnings - Sandin Common stock - Panther Paid in capital in excess of par -Panther Retained earnings-Panther Sales Cost of goods sold Depr. expense -building Depr expense - equipment Other expenses (800,000) (365,000) (800,000) 450,000 30,000 15,000 160,000 (350,000) 208,500 7,500 B000 98.000 8.000 Interest expense Gain on fixed asset sale (20,000) (16,000) Subsidiary income Dividends declared - Sandin Dividends declared - Panther Totals 10,000 20,000 a. Prepare a value analysis and determination of distribution of excess schedule for the investment in Sunshine on January 1, 2015. b. Write out the elimination entries for the December 31, 2016 consolidation. C. Complete the consolidated worksheet as of December 31, 2016. ution of Encess of asso V diary interest Common Stock erest Acquired Excess of Cost over Bock Account Adjusted Distribution Amorturation Schedule Account Adjusted Amount Current Year Prior Years Total Total Amortirations Parent Sub Intercompany Inventory Profit Deferral Parent Amount Beginning Ending Parent Profit Amount Sub Intercompany fixed asset profit deferral Parent Original profit Year of sale Realized in prior years Balance, start of year Reatred in Current year 2. On january 1, 2015, Panther Company acquired Sunshine Company, Purple Rain Company paid $60 per share for Box of Sunshine's common stock. The price paid by Purple reflected a control premium. The NCI shares were estimated to have a market value of $55 per share. On the date of acquisition, Sunshine had the following balance sheet: Sunshine Company lance Sheet 1-Jan-15 Assets Accounts Receivable Inventory $ Liabilities and Equity Accounts Payable $ 40.000 Bonds Payable 100 000 Common Stock Sipari 10.000 Paid in excess of par 90.000 Retained Earnings 112.000 60,000 0.000 60,000 200.000 (S0,000 72.000 (30,000) Buildings Accumulated Depreciation Equipment Accumulated Depreciation Total Assets $ 353,000 $ 352,000 Buildings, which have a 20-year life, were understated by $120,000. Equipment, which has a 50year life was understated by $40,000. Any remaining excess was considered goodwill. Purple used the simple equity method to account for its investment in Sunshine. January 1, 2016, Purple held merchandise sold to it from Sunshine for $12,000. This beginning inventory had an applicable gross profit of 20%. During 2016, Sunshine sold merchandise to Purple for $90,000. On December 31, 2016, Purple held $18,000 of this merchandise in its inventory (applicable gross profit rate of 25%). Purple owed Sunshine $20,000 on December 31 as a result of this intercompany sale. On January 1, 2016, Purple sold equipment with a book value of $35,000 to Sunshine $45,000. Purple also sold assets to nonaffiliates. During 2016, the equipment was used by Sunshine. Depreciation is computed over a 5-year life, using the straight-line method