On January 1, 2020, James Company purchased 100 percent of the outstanding voting stock of Nolan, Inc., for $1,000,000 in cash and other consideration. At the purchase date, Nolan had common stock of $500,000 and retained earnings of $185,000. James attributed the excess of acquisition-date fair value over Nolan's book value to a trade name with an estimated 25-year remaining useful life. James uses the equity method to account for its investment in Nolan. During the next two years, Nolan reported the following: Income Dividends Declared Inventory Transfers to James at Transfer Price 2020 $78,000 $25,000 $190,000 2021 85,000 27,000 210,000 Nolan sells inventory to James after a markup based on a gross profit rate. At the end of 2020 and 2021, 30 percent of the current year purchases remain in James's inventory. Using the attached Excel template, compute the following: 1. The Equity Method balance in James' Investment in Nolan, Inc., account as of December 31, 2021 2. Worksheet adjustments for the December 31, 2021 adjustments of James and Nolan. Use the following Codes to designate the purpose of the journal entry: Consolidation entries: (*G Recognition of intra-entity beginning inventory gross profit in current period consolidated net income. Downstream sale : are attributed to parent. (S) Elimination of subsidiary's stockholders' equity accounts along with recognition of the noncontrolling interest as of January 1. (A) Allocation of excess fair value over subsidiary's book value, unamortized balance as of January 1. (1) Elimination of intra-entity income remaining after *G elimination. (D) Elimination of intra-entity dividend. (E) Recognition of amortization expense for current year on excess fair value allocated to database. (P) Elimination of intra-entity receivable/peryable balances, (TI) Elimination of intra-entity sales/purchases balances. (G) Deferral of intra-entity ending inventory gross profit from current period consolidated net income and removal of intra-entity gross profit from ending inventory Formulate vour solution so that Nolan's aross profit rate on sales to . lames is treated as a variableDuring the next wor years, Normreported the following: Income Dividends Declared Inventory Transfers to James at Transfer Price 2020 $78,000 $25,000 $190,000 2021 85,000 27,000 210,000 Nolan sells inventory to James after a markup based on a gross profit rate. At the end of 2020 and 2021, 30 percent of the current year purchases remain in James's inventory. Using the attached Excel template, compute the following: 1. The Equity Method balance in James' Investment in Nole , Inc., account as of December 31, 2021 2. Worksheet adjustments for the December 31, 2021 adju ments of James and Nolan. Use the following Codes to designate the purpose of the journal entry: Consolidation entries: ("G) Recognition of intra-entity beginning inventory gross profit in current period consolidated net income. Downstream sales are attributed to parent. (5) Elimination of subsidiary's stockholders' equity accounts along with recognition of the noncontrolling interest as of January 1. (A) Allocation of excess fair value over subsidiary's book value, unamortized balance as of January 1 Elimination of intra-entity income remaining after *G elimination. (D) Elimination of intra-entity dividend. (E) Recognition of amortization expense for current year on excess fair value allocated to database. (P) Elimination of intra-entity receivable/payable balances, (TI) Elimination of intra-entity sales/purchases balances. (G) Deferral of intra-entity ending inventory gross profit from current period consolidated net income and removal of intra-entity gross profit from ending inventory. Formulate your solution so that Nolan's gross profit rate on sales to James is treated as a variable.\fA5 X V f Retained Earnings A B C D E 13 14 Investment Acco it 15 16 Cost 17 2020 Equity Earnings 18 Dividends 19 12/31/2020 Balance 20 21 2021 Equity Earnings 22 Dividends 2 12/31/2021 Balance Equity in Nolan Company Earnings 27 2020 Reported Net Income 28 El Profit Amortization