PLEASE NEED PART A AND D (THE CONSOLIDATED WORKSHEET) ONLY!!!!!!

On July 1, 2021, Truman Company acquired a 70 percent interest in Atlanta Company in exchange for consideration of $792,400 in cash and equity securities. The remaining 30 percent of Atlanta's shares traded closely near an average price that totaled $339,600 both before and after Truman's acquisition. In reviewing its acquisition, Truman assigned a $125,500 fair value to a patent recently developed by Atlanta, even though it was not recorded within the financial records of the subsidiary. This patent is anticipated to have a remaining life of five years. The following financial information is available for these two companies for 2021. In addition, the subsidiary's income was earned uniformly throughout the year. The subsidiary declared dividends quarterly. Revenues Operating expenses Income of subsidiary Net income Retained earnings, 1/1/21 Net income (above) Dividends declared Retained earnings, 12/31/21 Current assets Investment in Atlanta Land Buildings Total assets Liabilities Common stock Additional paid-in capital Retained earnings, 12/31/21 Total liabilities and stockholders' equity Truman $ (768,485) 418,000 (46,515) $ (397,000) $ (884,000) (397,000) 155,000 $(1,126,000) $ 542,585 821, 415 404,000 742,000 $ 2,510,000 $ (884,000) (95,000) (405,000) (1,126,000) $(2,510,000) Atlanta $ (536,000) 378,000 0 $ (158,000) $ (547,000) (158,000) 50,000 $ (655, 000) $ 423,000 0 256,000 690,000 $ 1,369,000 $ (394,000) (300,000) (20,000) (655,000) $(1,369,000) a. What is the excess fair-value assigned to patent and goodwill? b. How did Truman allocate the goodwill from the acquisition across the controlling and noncontrolling interests? c. How did Truman derive the Investment in Atlanta account balance at the end of 2021? d. Prepare a worksheet to consolidate the financial statements of these two companies as of December 31, 2021. At year-end, there were no intra-entity receivables or payables. Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D What is the excess fair-value assigned to patent and goodwill? Patent Goodwill Consolidation Entries Debit Credit Noncontrolling Consolidated Interest Totals Revenues Truman Atlanta Company Company $ (768,485) $ (536,000) 418,000 378,000 (46,515) 0 $ (397,000) $ (158,000) Operating expenses Net income of subsidiary Separate company net income Consolidated net income Net income attributable to NCI Net income attributable to Truman Retained earnings, 1/1/21 Net income Dividends declared Retained earnings, 12/31/21 $ (884,000) $ (397,000) 155,000 $ (1,126,000) $ (547,000) (158,000) 50,000 (655,000) Current assets $ 423,000 Investment in Atlanta 0 542,585 $ 821,415 404,000 742,000 Land 256,000 690,000 Buildings Patent Goodwill Total assets Liabilities Common stock Additional paid in capital $ 2,510,000 $ $ (884,000) $ (95,000) (405,000) 1,369,000 (394,000) (300,000) (20,000) (1,126,000) (655,000) Retained earnings, 12/31/21 Noncontrolling interest 7/1 Noncontrolling interest 12/31 Total liabilities and stockholders' equity $ (2,510,000) $ (1,369,000)