Can you all show me the step by step work to help me calculate parts D, E, F, and G that make up the Guidelines and Rubric for this excel workbook assignment, please?

This way, I can understand what must be done to get the correct dollar amounts for/of the total noncontrolling interest as of December 31, 20X6, the gain or loss on the constructive retirement of Stargell's bonds that should appear in the 20X7 consolidated income statement, consolidated entries that would appear in a three-part consolidation worksheet as of December 31, 20X7, and the dollar amounts that make up the three part worksheet for the preparation of consolidated financial statements for 20X7.