P Corporation acquired 70 percent ownership of S Company on January 1, 20X6, at underlying book value. At that date, the fair value of the noncontrolling interest was equal to 30 percent of the book value of S. On January 1, 20X8, Portfolio sold 1,000 shares of S Company for $20,000 to A Corporation and recorded a $5,000 gain. Trial balances for the companies on December 31, 20X8, contain the following data:

S Company's net income was earned evenly throughout the year. Both companies declared and paid their dividends on December 31, 20X8. P uses the fully adjusted equity method in accounting for its investment in S.

Required:

1. Prepare the elimination entries needed to complete a full consolidation worksheet for 20X8.
2. Prepare a consolidation worksheet for 20X8.

Use Excel formulas to make or evidence each of your calculations of all dollar amounts. Do not enter any dollar amounts directly, unless it is unavoidable for obvious reasons. Use the tab function at the bottom of the Excel file to complete the assignment.

Prepare and submit one Excel spreadsheet for this assignment. Use the following naming convention for your file: MyNameCTA4Option1.

Requirements:

• Show calculations for all questions.
• Support the writing portion of the assignment (if applicable) with credible sources.
• Use terms, evidence, and concepts from class readings, including professional business language.
• Review the weeks CT Assignment grading rubric for more information on expectations and how you will be graded.

Do not hesitate to ask your instructor if you have any questions about this assignment.