please show work or excel formulas thank you!

ollowing are the individual financial statements for Gibson and Davis for the year ending December 31, 2021 : Gibson acquired 60 percent of Davis on April 1,2021, for $619,500. On that date, equipment owned by Davis (with a five-year emaining life) was overvalued by $78,000. Also on that date, the fair value of the 40 percen 1 noncontrolling interest was $413,000. avis earned income evenly during the year but declared the $30,000 dividend on November 1, 2021. a. Prepare a consolidated income statement for the year ending December 31, 2021. o. Determine the consolidated balance for each of the following accounts as of December 31,2021 : Goodwill Equipment (net) Common stock Buildings (net) Dividends declared Complete this question by entering your answers in the tabs below. Goodwill Equipment (net) Common stock Buildings (net) Dividends declared Complete this question by entering your answers in the tabs below. Determine the consolidated balance for each of the following accounts as of December 31, 2021: Prepare a consolidated income statement for the year ending December 31, 2021. (Enter all amounts as positive values.)