please provide work or excel formulas

Asset acquisition vs. stock acquisition (fair value differs from book value) The following financial statement information is for an investor company and an investee company on January 1, 2022. On January 1, 2022, the investor company's common stock had a traded market value of \$35 per share, and the investee company's common stock had a traded market value of \$30 per share. Parts a. and b, are independent of each other. a. Assume the investor company issued 6,650 new shares of the investor company's common stock in exchange for all of the individually identifiable assets and liabilities of the investee company. The financial information presented, above, was prepared immediately before this transaction. Provide the Investor Company's balances (i.e., on the investor's books, before consolidation) for the following accounts immediately following the acquisition of the investee's net assets: - Receivables \& Inventories - Land - Property \& Equipment - Trademarks \& Patents - Investment in Investee - Goodwill - Liabilities - Common Stock (\$1 par) - Additional Paid-In Capital - Retained Earnings b. Assume the investor company issued 6,650 new shares of the investor company's common stock in exchange for all of the investee company's common stock. The financial information presented, above, was prepared immediately before this transaction. Provide the Investor Company's balances (i.e., on the investor's books, before consolidation) for the following accounts immediately following the acquisition of the investee's net assets: - Receivables \& Inventories - Land - Property \& Equipment - Trademarks \& Patents - Investment in Investee - Goodwill - Liabilities - Common Stock (\$1 par) - Additional Paid-In Capital - Retained Earnings Asset acquisition vs. stock acquisition (fair value differs from book value) The following financial statement information is for an investor company and an investee company on January 1, 2022. On January 1, 2022, the investor company's common stock had a traded market value of \$35 per share, and the investee company's common stock had a traded market value of \$30 per share. Parts a. and b, are independent of each other. a. Assume the investor company issued 6,650 new shares of the investor company's common stock in exchange for all of the individually identifiable assets and liabilities of the investee company. The financial information presented, above, was prepared immediately before this transaction. Provide the Investor Company's balances (i.e., on the investor's books, before consolidation) for the following accounts immediately following the acquisition of the investee's net assets: - Receivables \& Inventories - Land - Property \& Equipment - Trademarks \& Patents - Investment in Investee - Goodwill - Liabilities - Common Stock (\$1 par) - Additional Paid-In Capital - Retained Earnings b. Assume the investor company issued 6,650 new shares of the investor company's common stock in exchange for all of the investee company's common stock. The financial information presented, above, was prepared immediately before this transaction. Provide the Investor Company's balances (i.e., on the investor's books, before consolidation) for the following accounts immediately following the acquisition of the investee's net assets: - Receivables \& Inventories - Land - Property \& Equipment - Trademarks \& Patents - Investment in Investee - Goodwill - Liabilities - Common Stock (\$1 par) - Additional Paid-In Capital - Retained Earnings