Refer to the preceding facts for Panther€™s acquisition of Sandin common stock. On January 1, 2012, Sandin held merchandise sold to it from Panther for $20,000. During 2012, Panther sold merchandise to Sandin for $100,000. On December 31, 2012, Sandin held $25,000 of this merchandise in its inventory. Panther has a gross profit of 30%. Sandin owed Panther $15,000 on December 31 as a result of this intercompany sale. On January 1, 2011, Sandin sold equipment to Panther at a profit of $24,000. Panther also sold some fixed assets to nonaffiliates. Depreciation is computed over a 6-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