Refer to the preceding facts for Panther€™s acquisition of Sandin common stock. On January 1, 2012, Panther held merchandise sold to it from Sandin for $12,000. This beginning inventory had an applicable gross profit of 25%. During 2012, Sandin sold merchandise to Panther for $75,000. On December 31, 2012, Panther held $18,000 of this merchandise in its inventory.
This ending inventory had an applicable gross profit of 30%. Panther owed Sandin $20,000 on December 31 as a result of this intercompany sale.
On January 1, 2012, Panther sold equipment with a book value of $35,000 to Sandin for $50,000. Panther also sold some fixed assets to nonaffiliates. During 2012, the equipment was used by Sandin. Depreciation is computed over a 5-year life, using the straight-line method.
Required
1. Prepare a value analysis and a determination and distribution of excess schedule for the investment in Sandin.
2. Complete a consolidated worksheet for Panther Company and its subsidiary Sandin Company as of December 31, 2012. Prepare supporting amortization and income distribution schedules.
On January 1, 2011, Panther Company acquired Sandin Company. Panther paid $60 per share for 80% of Sandin€™s common stock. The price paid by Panther reflected a control premium. The NCI shares were estimated to have a market value of $55 per share. On the date of acquisition, Sandin had the following balance sheet:

Buildings, which have a 20-year life, were understated by $120,000. Equipment, which has a 5-year life, was understated by $40,000. Any remaining excess was considered good-will. Panther used the simple equity method to account for its investment in Sandin.
Panther and Sandin had the following trial balances on December 31, 2012:

Transcribed Image Text:

Sandin Company Balance Sheet January 1, 2011 Assets Liabilities and Equity 60,000 Accounts payable Accounts receivable Inventory Land.. 0,000 Bonds payable 60,000 Common stock ($1 par) 40,000 100,000 10,000 Accumulated depreciation(50,000 Retained earnings.. 112,000 72,000 Accumulated depreciation... on(30,000) Total assets $352,000 Toal liabilities and equity $352,000 Sandin Accounts Receivable Investment in Sandin Accumulated Depreciation. Accumulated Depreciation 5 Paid-In Capital in Excess of Par Retained Earnings, January 1 , 2012 .··········· Depreciation Expense-Buildings.. . Depreciation Expense-Equipment. . Other Expenses Interest Expense Gain on Sale of Fixed Assets . . . . .. . .. Subsidiary lncome.. 0