I need full consolidated worksheet

WOEK Padre, Inc., buys 80 percent of the outstanding common stock of Sierra Corporation on January 1, 2021, for $760,960 cash. At the acquisition date, Sierra's total fair value, including the noncontrolling interest, was assessed at $951,200 although Sierra's book value was only $619,000. Also, several individual items on Sierra's financial records had fair values that differed from their book values as follows: Land Buildings and equipment (10-year remaining life) Copyright (20-year remaining life) Notes payable (due in 8 years) Book Value $ 67,400 335,000 197,000 (165,000) Fair Value $ 290,400 299,000 323,000 (145, 800) For internal reporting purposes, Padre, Inc., employs the equity method to account for this investment. The following account balances are for the year ending December 31, 2021, for both companies. Sierra $ (636,600) 417,000 13,000 9,850 6,750 $ $ Padre $(1,465,280) 788,000 308,000 0 50,200 (147,920) $ (467,000) $(1,402,500) (467,000) 260,000 $(1,609,500) $ 939,620 856,880 309,000 976,000 Revenues Cost of goods sold Depreciation expense Amortization expense Interest expense Equity in income of Sierra Net income Retained earnings, 1/1/21 Net income Dividends declared Retained earnings, 12/31/21 Current assets Investment in Sierra Land Buildings and equipment (net) Copyright Total assets Accounts payable Notes payable Common stock Additional paid-in capital Retained earnings (above) Total liabilities and equities (190,000) (459,000) (190,000) 65,000 (584,000) 494,450 $ es $ $ 3,081,500 $ (200,000) (522,000) (300,000) (450,000) (1,609,500) $ (3,081,500) 67,400 322,000 187,150 $ 1,071, 000 $ (162,000) (165,000) (100,000) (60,000) (584,000) $(1,071,000) At year-end, there were no intra-entity receivables or payables. At year-end, there were no intra-entity receivables or payables. Prepare a worksheet to consolidate the financial statements of these two companies. (For accounts where multiple consolidatic entries are required, combine all debit entries into one amount and enter this amount in the debit column of the worksheet. Similarly, combine all credit entries into one amount and enter this amount in the credit column of the worksheet. Input all amounts as positive values.) PADRE INC., AND SIERRA CORPORATION Consolidated Worksheet For Year Ending December 31, 2021 Consolidation Entries Accounts Padre Sierra Debit Credit Noncontrolling Interest Consolidated Totals S 2,101.880 Revenues $ (1.465 280) $ (636 600) Padre, Inc., buys 80 percent of the outstanding common stock of Sierra Corporation on January 1, 2021, for $760,960 cash. At the acquisition date, Sierra's total fair value, including the noncontrolling interest, was assessed at $951,200 although Sierra's book value was only $619,000. Also, several individual items on Sierra's financial records had fair values that differed from their book values as follows: Land Buildings and equipment (10-year remaining life) Copyright (20-year remaining life) Notes payable (due in 8 years) Book Value $ 67,400 335,000 197,000 (165,000) Fair Value $ 290,400 299,000 323,000 (145,800) Sierra $ (636,600) 417,000 13,000 9,850 6,750 $ $ Padre $(1,465,280) 788,000 308,000 0 50,200 (147,920) $ (467,000) $(1,402,500) (467,000) 260,000 $(1,609,500) $ 939,620 856,880 309,000 976,000 Revenues Cost of goods sold Depreciation expense Amortization expense Interest expense Equity in income of Sierra Net income Retained earnings, 1/1/21 Net income Dividends declared Retained earnings, 12/31/21 Current assets Investment in Sierra Land Buildings and equipment (net) Copyright Total assets Accounts payable Notes payable Common stock Additional paid-in capital Retained earnings (above) Total liabilities and equities (190,000) (459,000) (190,000) 65,000 (584,000) 494,450 $ es $ $ 3,081,500 $ (200,000) (522,000) (300,000) (450,000) (1,609,500) $ (3,081,500) 67,400 322,000 187,150 $ 1,071, 000 $ (162,000) (165,000) (100,000) (60,000) (584,000) $(1,071,000) At year-end, there were no intra-entity receivables or payables. Prepare a worksheet to consolidate the financial statements of these two companies. (For accounts where multiple consolidation entries are required, combine all debit entries into one amount and enter this amount in the debit column of the worksheet. Similarly, combine all credit entries into one amount and enter this amount in the credit column of the worksheet. Input all amounts as positive values.) PADRE INC., AND SIERRA CORPORATION Consolidated Worksheet For Year Ending December 31, 2021 Consolidation Entries Accounts Padre Sierra Debit Credit Noncontrolling Interest $ (1.465,280) $ (636,600) 788.000 417,000 308.000 13,000 0 9.850 Consolidated Totals $ 2,101,880 1,205,000 317,400 16.150 3.600 6.300 50.200 6.750 2.400 59.350 0 0 147.920 Revenues Cost of goods sold Depreciation expense Amortization expense Interest expense Equity in income of Sierra Separate company net income Consolidated net income NI to noncontrolling interest Ni to Padre Company Retained earnings. 1/1/21 (147,920) $ (467,000) S (190.000) $(1.402.500) $ (459.000)