how to create a consolidated worksheet to arrive at a consolidated balance sheet totals as of the
Fantastic news! We've Found the answer you've been seeking!
Question:
how to create a consolidated worksheet to arrive at a consolidated balance sheet totals as of the acquisition by using the 3 different methods: Equity, Initial Value, and Partial-Equity Method. Use Excel and different tabs for each method Equity, Initial Value, Partial-Equity.
Transcribed Image Text:
Company A acquired 100% of Company B's voting stock on January 1, 2018 by issuing 10,000 shares of its $10 par value common stock. Company A's common stock had a fair value of $14 per share at that time. Company B'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. A Company B Company Revenues COGS (485,000) 160,000 Depreciation Exp 130,000 Net Income (190,000) 70,000 52,000 (68,000) R/E, 1/1 (609,000) (40,000) Net income (above) (68,000) Dividends paid 175,500 40,000 R/E, 12/31 (68,000) Cash 268,000 17,000 Trademark 427,500 58,000 Buildings & Eqp (net) 713,000 161,000 Total Assets 236,000 Liabilities (190,000) (103,000) Common Stock (600,000) (60,000) APIC (90,000) (5,000) R/E (above) (68,000) Total Liabilities & Equity (236,000) Company A acquired 100% of Company B's voting stock on January 1, 2018 by issuing 10,000 shares of its $10 par value common stock. Company A's common stock had a fair value of $14 per share at that time. Company B'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. A Company B Company Revenues COGS (485,000) 160,000 Depreciation Exp 130,000 Net Income (190,000) 70,000 52,000 (68,000) R/E, 1/1 (609,000) (40,000) Net income (above) (68,000) Dividends paid 175,500 40,000 R/E, 12/31 (68,000) Cash 268,000 17,000 Trademark 427,500 58,000 Buildings & Eqp (net) 713,000 161,000 Total Assets 236,000 Liabilities (190,000) (103,000) Common Stock (600,000) (60,000) APIC (90,000) (5,000) R/E (above) (68,000) Total Liabilities & Equity (236,000)
Expert Answer:
Answer rating: 100% (QA)
Ans part A consideration transferred values In Dollars In In Dollars Dollars 140000 Less Book value ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Following are separate financial statements of Michael Company and Aaron Company as of December 31, 2013 (credit balances indicated by parentheses). Michael acquired all of Aarons outstanding voting...
-
If two krypton atoms are held together by a stabilization energy of 1.005 kJ/mol at what temperature would you expect these atoms to transition from bound to unbound? Show your thought process for...
-
Why is it a nontax advantage for corporations to be able to trade their stock on the stock market?
-
The following information is available for Wright Auto Supply at December 31, 2019. Required: 1. Prepare a single-step income statement for the year ended December 31, 2019. 2. Prepare a...
-
Compare and contrast the ethical approaches of its legal, therefore, its ok and the ends justify the means. Are there similarities? Are there differences?
-
Jims Outfitters, Inc., makes custom fancy shirts for cowboys. The shirts could be flawed in various ways, including flaws in the weave or color of the fabric, loose buttons or decorations, wrong...
-
If Bob faces a 20% chance of losing $20 or an 80% chance of losing nothing. What is the expected loss and variance?
-
Common Stock A Probability 0.25 0.50 0.25 Return 13% 16% 21% Syntex, Inc. is considering an investment in one of two common stocks. Given the information that follows, which investment is better,...
-
Wash Company sells washing machines. On January 1, 2018, it had 20 units in inventory, valued at \(\$ 400\) per unit. During 2018, it sold 200 units at \(\$ 700\) per machine. Wash Company purchased...
-
Discuss the role of organisational theories and HR interventions to provide strategies to manage the process of downsizing more effectively;
-
Describe some of the difficulties users have encountered with MRP.
-
John's basis in the painting in problem 67 is: a. \(\$ 0\) b. \(\$ 25,000\) c. \(\$ 30,000\) d. \(\$ 39,000\) e. \(\$ 42,250\) problem 67 John sold a painting in February 2018 for \(\$ 40,000\). He...
-
Discuss the benefits and requirements of MRP.
-
B. Calculate the effective resistance between P and Q?
-
Why is a help desk and production support critical to system implementations? Discuss its interrelationship with the problem management and reporting system.
-
Alpha Company Owns 80 percent of the voting stock of beta Company. Alpha and Beta reported the following account information from their year-end separate financial records: What is the total for...
-
Government officials of the City of Jones expect to receive general fund revenues of $400,000 in 2020 but approve spending only $380,000. Later in the year, as they receive more information, they...
-
Which of the following is true about the statement of cash flows for the proprietary funds of a state or local government? a. The indirect method of reporting cash flows from operating activities is...
-
Eatern and Sons Ltd accounts for its manufacturing costs using a job order costing system and has provided the following production data during June 2019. Job Z241 was in process as of 1 June with a...
-
Abbott Ltd produces a chemical used to clean showers in a single process in the Production Department. Raw materials in the form of chemicals are added at the beginning of the process, and a litre...
-
The April 2019 transactions of Jackson Productions Ltd, which uses a job order costing system, are shown below. (Ignore GST.) 1. Raw materials purchased, $342 000. 2. Raw materials issued to...
Study smarter with the SolutionInn App