Consolidation spreadsheet for continuous sale of inventory - Equity method Assume that a parent company acquired a subsidiary on January 1, 2010. The purchase price was $500,000 million in excess of the subsidiary's book value of Stockholders' Equity on the acquisition date, and that excess was assigned to the following AAP assets: Original Original Useful AAP Asset Property, plant and equipment (PPE), net $100,000 Customer list Royalty agreement Goodwill Amount Life (years) 20 165,000 135,000 100,000 $500,000 10 10 indefinite The AAP assets with a definite useful life have been amortized as part of the parent's equity method accounting. The Goodwill asset has been tested annually for impairment, and has not been found to be impaired. Assume that the parent company sells inventory to its wholly owned subsidiary. The subsidiary, ultimately, sells the inventory to customers outside of the consolidated group. You have compiled the following data for the years ending 2012 and 2013: Gross Profit Remaining Inventory in Unsold Sales Receivable Inventory (Payable) $19,580 $27,400 2012 $43,700 $12,797 $13,437 2013 $68,000