please show work or if possible, show excel sheet with formulas thank you!

\begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ GIANT COMPANY AND SMALL COMPANY } \\ \hline \multicolumn{6}{|c|}{ Consolidation Worksheet } \\ \hline \multicolumn{6}{|c|}{ For Year Ending December 31, 2021} \\ \hline \multirow[b]{2}{*}{ Accounts } & \multirow[b]{2}{*}{ Giant } & \multirow[b]{2}{*}{ Small } & \multicolumn{2}{|c|}{ Consolidation Entries } & \multirow[b]{2}{*}{ConsolidatedTotals} \\ \hline & & & Debit & Credit & \\ \hline Revenues & $(1,151,300) & $(506,500) & & & \\ \hline Cost of goods sold & 556,000 & 109,500 & & & \\ \hline Depreciation expense & 170,500 & 170,000 & & & \\ \hline Equity income of Small & (219,200) & 0 & & & \\ \hline Net income & $(644,000) & $(227,000) & & & \\ \hline Retained earning, 1/1/21 & $(1,820,000) & $(714,000) & & & \\ \hline Net income (above) & (644,000) & (227,000) & & & \\ \hline Dividends declared & 300,000 & 90,000 & & & \\ \hline Retained earnings, 12/31/21 & $(2,164,000) & $(851,000) & & & \\ \hline Current assets & $683,000 & $353,000 & & & \\ \hline Investment in Small & 1,182,000 & 0 & & & \\ \hline Land & 480,000 & 191,000 & & & \\ \hline Buildings (net) & 305,000 & 513,000 & & & \\ \hline Equipment (net) & 679,000 & 359,000 & & & \\ \hline Goodwill & 0 & 0 & & & \\ \hline Total assets & $3,329,000 & $1,416,000 & & & \\ \hline Liabilities & $(915,000) & $(395,000) & & & \\ \hline Common stock & (250,000) & (170,000) & & & \\ \hline Retained earnings (above) & (2,164,000) & (851,000) & & & \\ \hline Total liabilities and equity & $(3,329,000) & $(1,416,000) & 0 & 0 & \\ \hline \end{tabular} Determine the totals to be reported by this business combination for the year ending December 31,2021 . (Input all amounts as positive values.) a. How was the $219,200 Equity in Income of Small balance computed? b. Determine the totals to be reported by this business combination for the year ending December 31, 2021. c. Prepare a consolidation worksheet for Giant and Small for the year ending December 31, 2021. d. If Giant determined that the entire amount of goodwill from its investment in Small was impaired in 2021, what journal entry would Giant make to record such impairment? Answer is not complete. Complete this question by entering your answers in the tabs below. If Giant determined that the entire amount of goodwill from its investment in Small was impaired in 2021, what journal entry would Giant make to record such impairment? (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) Giant acquired all of Small's common stock on January 1, 2017, in exchange for cash of $770,000. On that day, Small reported common stock of $170,000 and retained earnings of $400,000. At the acquisition date, $61,800 of the fair-value price was attributed to undervalued land while $78,000 was assigned to undervalued equipment having a 10 -year remaining life. The $60,200 unallocated portion of the acquisition-date excess fair value over book value was viewed as goodwill. Over the next few years, Giant applied the equity method to the recording of this investment. The following are individual financial statements for the year ending December 31, 2021. On that date, Small owes Giant \$14,400. Small declared and paid dividends in the same period. Credits are indicated by parentheses. a. How was the $219,200 Equity in Income of Small balance computed? b. Determine the totals to be reported by this business combination for the year ending December 31,2021 . c. Prepare a consolidation worksheet for Giant and Small for the year ending December 31,2021. d. If Giant determined that the entire amount of goodwill from its investment in Small was impaired in 2021, what journal entry would Giant make to record such impairment