In excel with $3$ new tabs for equity, initial value, and partial equity methodsCompany A acquired $100\%$ of Company B$\text{'}$s voting stock on January $1,2018$ by issuing $10,000$ shares of its $$10$ par value common stock.

Company A$\text{'}$s common stock had a fair value of $$14$ per share at that time. Company B$\text{'}$s stockholder's equity was $$105,000$ at date of acquisition.

The trademark was undervalued by $$10,000.$ It has an indefinite life. Equipment $($with a $5$ year life$)$ was undervalued by $$5,000.$ A customer list that had

been created internally had an estimated useful life of $20$ years was valued at $$20,000.$

Following are the financial statements for the two companies for the year ending December $31,2018.$ Credit balances are indicated by $($parentheses$).$

Complete the trial balance of A Company $($calculate income of sub and investment in sub$)$ by using the three different investing accounting methods;

Equity, Intial Value, and Partial Equity $($use individual tabs following problem$)$

Then, continue by preparing a consolidated worksheet for year

ended Dec. $31,2018.$ Include your consolidation and elimination

entries in journal form with the exam.