Worksheet, consolidated taxation, simple equity, inventory, land. On January 1, 2011, Pe...

Worksheet, consolidated taxation, simple equity, inventory, land. On January 1, 2011, Pepper Company purchases 80% of the common stock of Salty Company for $270,000. On this date, Salty has total owners’ equity of $300,000. The excess of cost over book value is due to goodwill. For tax purposes, goodwill is amortized over 15 years.

During 2011, Pepper appropriately accounts for its investment in Salty using the simple equity method.

During 2011, Pepper sells merchandise to Salty for $50,000, of which $10,000 is held by Salty on December 31, 2011. Pepper’s gross profit on sales is 40%.

During 2011, Salty sells some land to Pepper at a gain of $10,000. Pepper still holds the land at year-end. Pepper and Salty qualify as an affiliated group for tax purposes and, thus, will file a consolidated tax return. Assume a 30% corporate income tax rate.

The following trial balances are prepared on December 31, 2011:

Prepare a consolidated worksheet for Pepper Company and subsidiary Salty Company for the year ended December 31, 2011. Include the determination and distribution of excess schedule and the income distribution schedules.