Baugh Company purchased 100% of the outstanding stock of Wiley, Inc., on January 1, 2022, for...

 

 

  

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.).

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