Prepare a consolidated income statement and balance sheet for the fiscal year ending December 31, 2021. You
Question:
Prepare a consolidated income statement and balance sheet for the fiscal year ending December 31, 2021. You will need to recreate the equity method journal entries for Paper Company for the year and use a consolidation worksheet to complete this task.
Use the relevant tabs in the assignment spreadsheet. Information (also provided without description in the Trial Balance – 2021 tab): In 2020 Paper Company acquired 80% of the common stock of Scale Company for $193,800 in cash. The FV of the net assets was determined to be $217,250. This included an unrecorded patent worth $12,000, undervaluation of buildings and equipment of $41,250, and undervalued land of $14,000. Any remaining differential was determined to be due to goodwill. Scale Company reported common stock of $100,000 and retained earnings of $50,000 at the time of acquisition. Scale Company had Accumulated Depreciation at the time of $60,000 on its buildings and equipment. In 2021 Paper Company's accounting staff determined that the value of the goodwill related to the acquisition was impaired and Goodwill was now best valued at $17,500. In 2021 Scale Company sold inventory to Paper Company for $4,500 and had an original cost of $2,500. Paper Company sold inventory to Scale Company for $8,000 when it had an original cost of $5,000. Neither Paper nor Scale Company had sold the inventory to a third party by the end of December 31, 2021. Paper Company sold land to Scale Company originally costing $8,000 for $13,500.
Presume Paper Company uses the full equity method to account for the activities of Scale Company.
1. Please use the information in the following tabs to complete the project. You will need to create consolidated income statements and balance sheets and consolidation worksheets for 2021. Assume the Paper Company uses the Full Equity Method.
2. Do not simply type in numbers into the consolidation worksheets and financial statements. Instead, use formulas, cell references, and etc.
3. I will expect to see your final financial statements change if I change something in any of the relevant statements. I also expect to see the statements articulate from year to year and in each period.
Valuation The Art and Science of Corporate Investment Decisions
ISBN: 978-0133479522
3rd edition
Authors: Sheridan Titman, John D. Martin