Baugh Company purchased 100% of the outstanding stock of Wiley, Inc., on January 1, 2022, for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Baugh Company purchased 100% of the outstanding stock of Wiley, Inc., on January 1, 2022, for a purchase price of S1,200,000. At the acquisition date, Wiley's book value consisted of common stock of $600,000 and retained earnings of $250,000. Baugh attributed the cost over book to a patent with an estimated 20-year remaining useful life. Baugh uses the equity method to account for its investment in Wiley. During the next two years, Wiley reporting the following: Inventory Transfers Dividends to Baugh Year Income Declared at Transfer Price 2022$120,000 $42,000 S250,000 2023 135,000 45,000 280,000 Wiley sells inventory to Baugh after a markup based on a gross profit rate. At the end of 2022 and 2023, 40 percent of the current year purchases remain in Wiley's inventory. Required Create an Excel spreadsheet that computes the following: 1. Investment in Wiley, Ic., account as of December 31, 2023. 2. Worksheet adjustments (consolidation journal entries) for the December 31, 2023, consolidation of Baugh anu wmey of Baugh and Wilcy. Your solution should be formulated so that Wiley's gross profit rate on sales to Baugh is treated as a variable (this requires the use of formulas in your Excel spreadsheet!). Most amounts should be formula-driven so that when you change the gross profit rate (or any other variable), all other numbers update including the equity income, balance in the investment account, and amount of the worksheet adjustments. Use formulas everywhere you reasonably can. Not sure where to start or what all to include in your solution? Here are suggestions: o Acquisition Date Allocation including the calculation of any amortization. o Intra-entity inventory transfers (this could be just a small table calculating the amount of unrealized intra-entity profit) - this one isn't necessary because you can embed the calculations elsewhere, but seeing it separately usually helps students, and the more detail you have, the more partial credit I can award if you make mistakes. • Equity Income for each year (these are needed to help arrive at the investment balance). o Investment in Wiley • Consolidation entries o I also recommend having a small section somewhere in the worksheet with "given" information so that any formulas you use can pull from it (Wiley's income and dividends, etc.). Baugh Company purchased 100% of the outstanding stock of Wiley, Inc., on January 1, 2022, for a purchase price of S1,200,000. At the acquisition date, Wiley's book value consisted of common stock of $600,000 and retained earnings of $250,000. Baugh attributed the cost over book to a patent with an estimated 20-year remaining useful life. Baugh uses the equity method to account for its investment in Wiley. During the next two years, Wiley reporting the following: Inventory Transfers Dividends to Baugh Year Income Declared at Transfer Price 2022$120,000 $42,000 S250,000 2023 135,000 45,000 280,000 Wiley sells inventory to Baugh after a markup based on a gross profit rate. At the end of 2022 and 2023, 40 percent of the current year purchases remain in Wiley's inventory. Required Create an Excel spreadsheet that computes the following: 1. Investment in Wiley, Ic., account as of December 31, 2023. 2. Worksheet adjustments (consolidation journal entries) for the December 31, 2023, consolidation of Baugh anu wmey of Baugh and Wilcy. Your solution should be formulated so that Wiley's gross profit rate on sales to Baugh is treated as a variable (this requires the use of formulas in your Excel spreadsheet!). Most amounts should be formula-driven so that when you change the gross profit rate (or any other variable), all other numbers update including the equity income, balance in the investment account, and amount of the worksheet adjustments. Use formulas everywhere you reasonably can. Not sure where to start or what all to include in your solution? Here are suggestions: o Acquisition Date Allocation including the calculation of any amortization. o Intra-entity inventory transfers (this could be just a small table calculating the amount of unrealized intra-entity profit) - this one isn't necessary because you can embed the calculations elsewhere, but seeing it separately usually helps students, and the more detail you have, the more partial credit I can award if you make mistakes. • Equity Income for each year (these are needed to help arrive at the investment balance). o Investment in Wiley • Consolidation entries o I also recommend having a small section somewhere in the worksheet with "given" information so that any formulas you use can pull from it (Wiley's income and dividends, etc.).
Expert Answer:
Answer rating: 100% (QA)
To create an Excel spreadsheet that computes the required information follow these steps Step 1 Set up the spreadsheet Create a new Excel spreadsheet ... View the full answer
Related Book For
Accounting Tools for Business Decision Making
ISBN: 9781119571056
7th edition
Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso
Posted Date:
Students also viewed these accounting questions
-
Explain the following terms in view of middleware: a. Publisher/Subscriber model b. Fire and Forget Model c. Connection-oriented model d. Queued model
-
Australias CGT system in the past utilized indexation to ensure that only after-inflation gains were subject to CGT. Currently, newly acquired assets are generally subject to discounting rather than...
-
In 2009 Yoda Company purchased all of the outstanding stock of SOLO Company at book value. Yoda accounts for its purchase of SOLO using initial value and SOLO does not pay any dividends. On January 1...
-
Because of its seemingly insatiable "addiction to oil," in the past the US was and still purchases crude oil primarily from countries in the Middle East. It is said that each day, the average payment...
-
The following data represent the number of cars that arrived at a McDonalds drive-through between 11:50 a.m. and 12:00 noon each Wednesday for the past 50 weeks: (a) Construct a frequency...
-
Select a peer-review article of your choice, from any chemistry based area of research and writes a detailed review of the problem/subject being investigated. You will include and introduction,...
-
Debit-to-Equity Ratio Calculate the company's 2019 debt-to-equity ratio and compare the result to the industry average. Use the following financial data for Brenner Instruments Sales revenue.. Cost...
-
A 0.20-m-diameter, thin-walled steel pipe is used to transport saturated steam at a pressure of 20 bars in a room for which the air temperature is 25C and the convection heat transfer coefficient at...
-
having trouble with the remaing incorrect bubbles (the ones that are red) The following are comparative balance sheets for Bonita Company. BONITA Company Comparative Balance Sheets December 31 Assets...
-
1. Critically analyze the social media effort made by Gillette India in terms of the zones of social media. 2. Thoroughly assess the effectiveness of the campaign "The Barbershop Girls of India."...
-
A swimmer in the ocean observes one day that the ocean surface waves are periodic and resemble a sine wave. The swimmer estimates that the vertical distance between the crest and the trough of each...
-
Pastina Company sells various types of pasta to grocery chains as private label brands. The company's reporting year-end is December 31. The unadjusted trial balance as of December 31, 2024, appears...
-
The application of new technologies in business is transforming the landscape of International Trade and pushing the frontiers of how business is done domestically, as well as internationally. While...
-
A company produces three products, X, Y, and Z. Each unit of Product X requires 2 hours of labor, 1 hour of machine time, and 3 hours of assembly time. Each unit of Product Y requires 1 hour of...
-
Use a DCF valuation to estimate the company's worth. Discuss the pros and cons of using this method. Cash and cash equivalents Trade receivables Receivables from financing activities Inventories...
-
1.Suppose that our operating system is a batch multiprogramming, where SVC-IO's are asynchronous, and we have two different SVC-IO, SVC-IO-Disk and SVC-IO-Printer. Assume that you have the...
-
If n=540 and p p ^ (p-hat) =0.05, find the margin of error at a 90% confidence level Give your answer to three decimals
-
President Lee Coone has asked you to continue planning for an integrated corporate NDAS network. Ultimately, this network will link all the offices with the Tampa head office and become the...
-
In November 2022, after having incorporated Cookie Creations Inc., Natalie begins operations. She has decided not to pursue the off er to supply cookies to Biscuits. Instead, the company will focus...
-
Gonzalez Company has a balance in its Accounts Payable control account of $8,250 on January 1, 2022. The subsidiary ledger contains three accounts: Rye Company, balance $3,000; Keyes Company, balance...
-
Penn Farms is a grower of hybrid seed corn for Bend Genetics Corporation. It has had two exceptionally good years and has elected to invest its excess funds in bonds. The following selected...
-
Refer to the Action feature, Channel Stuffing, on page 19. Suppose that performance bonuses based on revenues were eliminated and this behavior ceases. Would you favor eliminating performance-based...
-
Refer to the Action feature, Palliative Care Unit, on page 5. What type of costs in a hospital might be difficult to split between the PCU and non-PCU areas? What type of costs would be easy to...
-
Place the letter of the appropriate accounting cost in Column 2 in the blank next to each decision category in Column 1. Column 1 Analyzing executive performance Determining whether to produce...
Study smarter with the SolutionInn App