80%, equity, sales-type lease, merchandise. Refer to the preceding facts for Press’s acquisition of Simon common stock. Press uses the simple equity method to account for its investment in Simon. On January 1, 2016, Press held merchandise acquired from Simon for $10,000. During 2016, Simon sold $40,000 worth of merchandise to Press. Press held $12,000 of this merchandise at December 31, 2016. Press owed Simon $6,000 on December 31 as a result of this intercompany sale. Simon has a gross profit rate of 25%.
On January 1, 2016, Simon signed a 5-year lease with Press for the rental of equipment, which has a 5-year life. Payments of $23,363 are due each January 1, and there is a guaranteed residual value of $10,000 at the end of the five years. The market value of the equipment at the inception of the lease was $100,000. The cost of the equipment to Press was $85,000. Press has a 12% implicit rate on the lease. The amortization table shown on next page was prepared for the lease.
Prepare the worksheet necessary to produce the consolidated financial statements for Press Company and its subsidiary Simon Company for the year ended December 31, 2016. Include the determination and distribution of excess and income distribution schedules.