In: Accounting
Paradise is the parent company and purchases a stake in Summit, the subsidiary. Paradise pays $720,000 for a 60% interest in Summit at a point when the total book value of Summit is $1,050,000. Summit has land with a fair market value that is $8,000 higher than its book value. Summit also has buildings, with a remaining five-year life, with market values $60,000 higher than book values and inventory valued on the books $40,000 lower than fair market value. Summit's equipment, with a remaining three-year life, has a book that is $3,000 higher than market value. Required: Complete the consolidation worksheet and the required consolidation entries. This submission is to be done in excel.
| Consolidation Worksheet | |
| Purchase Price Paid | $ 720,000.00 | 
| % Holding in Sage | 60% | 
| Implied Value of Sage =720000/60%= | $ 1,200,000.00 | 
| NCI at Implied Value = | 480,000 | 
| Allocation of Difference | 60% Parent | 40% NCI | Total | |
| m | Purchase Consideration and Total Implied value | 720,000 | 480,000 | 1,200,000 | 
| Less Book Value of Equity Acquired | ||||
| n | Total Book Value | 630,000 | 420,000 | 1,050,000 | 
| o | Difference between Impied and Book Value=m-n | 90,000 | 60,000 | 150,000 | 
| Allocation of Difference | ||||
| Land | 4,800 | 3,200 | 8,000 | |
| Building | 36,000 | 24,000 | 60,000 | |
| Inventory | 24,000 | 16,000 | 40,000 | |
| Equipment | (1,800) | (1,200) | (3,000) | |
| Good Will Recognized (Balance Amount of excess of Implied value over Fair Value ) | 27,000 | 18,000 | 45,000 | |
| Total Difference between Implied and Book Value Allocated | 90,000 | 60,000 | 150,000 | 
| Consolidation Entry | ||
| Account Title | Dr $ | Cr $ | 
| Equity Capital (Summit) | 1,050,000 | |
| Investment in Summit | 720,000 | |
| NCI | 480,000 | |
| Difference between Implied and Book Value | 150,000 | |
| Land | 8,000 | |
| Building | 60,000 | |
| Inventory | 40,000 | |
| Equipment | 3,000 | |
| Goodwill | 45,000 | |
| Difference between Implied and Book Value | 150,000 |