Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Alpha Company purchased 100% of the outstanding stock of Beta, Inc., on January 1, 2023, for a purchase price of $1,600,000. At the acquisition date,

Alpha Company purchased 100% of the outstanding stock of Beta, Inc., on January 1, 2023, for a purchase price of $1,600,000. At the acquisition date, Beta's book value consisted of common stock of $800,000 and retained earnings of $550,000. Alpha attributed the cost over book to machinery with an estimated 10-year remaining useful life. Alpha uses the equity method to account for its investment in Beta. During the next two years, Beta reported the following:

YearIncomeDividends DeclaredInventory Transfers to Alpha at Transfer Price
2023$270,000$60,000$280,000
2024$305,000$75,000$310,000

Beta sells inventory to Alpha after a markup based on a gross profit rate. At the end of 2023 and 2024, 30 percent of the current year's purchases remain in Alpha's inventory. 

Required 

Create an Excel spreadsheet that computes the following: Investment in Beta, Inc., account as of December 31, 2024. Worksheet adjustments (consolidation journal entries) for the December 31, 2024, consolidation of Alpha and Beta. Your solution should be formulated so that Beta's gross profit rate on sales to Alpha is treated as a variable (this requires using 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.

Step by Step Solution

3.43 Rating (162 Votes )

There are 3 Steps involved in it

Step: 1

Investment in Beta Inc analysis 01012023 to 31122024 Consideration paid fair value 01012023 1600000 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial management theory and practice

Authors: Eugene F. Brigham and Michael C. Ehrhardt

12th Edition

978-0030243998, 30243998, 324422695, 978-0324422696

More Books

Students also viewed these Finance questions

Question

In Problems 11 68, solve each equation. 5 (2x 1) = 10

Answered: 1 week ago