80%, equity, effective interest bonds purchased last year, inventory profits. Refer to the preceding facts for Postman’s acquisition of 80% of Spartan’s common stock and the bond transactions. Postman...

80%, equity, effective interest bonds purchased last year, inventory profits. Refer to the preceding facts for Postman’s acquisition of 80% of Spartan’s common stock and the bond transactions. Postman uses the simple equity method to account for its investment in Spartan. On January 1, 2016, Postman held merchandise acquired from Spartan for $12,000. During 2016, Spartan sold $25,000 worth of merchandise to Postman. Postman held $10,000 of this merchandise at December 31, 2016. Postman owed Spartan $6,000 on December 31 as a result of these intercompany sales. Spartan has a gross profit rate of 25%.

Postman and Spartan had the following trial balances on December 31, 2016:

Prepare the worksheet necessary to produce the consolidated financial statements for Postman Company and its subsidiary Spartan Company for the year ended December 31, 2016. Include the determination and distribution of excess and income distribution schedules.