Answered step by step
Verified Expert Solution
Question
1 Approved Answer
REQUIRED Create an Excel spreadsheet that computes the following: 1. Investment in Goldberg, Inc. account as of December 31, 2024. 2. Worksheet adjustments (consolidation journal
REQUIRED Create an Excel spreadsheet that computes the following: 1. Investment in Goldberg, Inc. account as of December 31, 2024. 2. Worksheet adjustments (consolidation journal entries) for the December 31, 2024, consolidation of Galvin and Goldberg. 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 to include in your solution? You can use the as a template to complete the assignment. Alternatively, you can build your own Excel solution from scratch and the following are suggestions of items to include if you choose that option: - Acquisition Date Allocation including the calculation of any amortization. award if you make mistakes. - Equity Income for each year (these are needed to help arrive at the investment balance). - Investment in Goldberg - Consolidation entries - I also recommend having a small section somewhere in the worksheet with "given" information so that any formulas you use can pull from it (Goldberg's income and dividends, etc.). Consolidation Project - Excel Case Study - Guide Acquisition Date Allocation Consideration transferred Goldberg Common Stock Goldberg Retained Earnings Cost over book Account Given Amount Formula LivenLifeFormulaAmort Inventory Goldberg sells to Galvin 2023 2024 Remaining Given Given Intra-entity Inventory Transfers Equity in Goldberg, Inc. Earnings 2023 Reported Net Income Formula El profit Formula Amortization Equity earnings Formula Formula 2024 Reported Net Income Formula Bl profit: El profit Amortization Equity earnings Goldberg, Inc, Dividends 2023 Given 2024 Given Goldberg, Inc. Income 2023 Given 2024 Given Formula Formula Formula Formula - The amounts labeled "given" are provided in the case study and will just be entered into the spreadsheet. - The cells labeled "formula" should include formulas. They can be as simple as "=H20" for the 2023 reported net income in the calculation of Equity in Goldberg Earnings. That formula is just pulling a number from somewhere else in the spreadsheet. Or, it could be more complicated and include references to other cells and have mathematical operations like the formula at the end of the consolidation entries that will calculate whether the investment account goes to zero or not. REQUIRED Create an Excel spreadsheet that computes the following: 1. Investment in Goldberg, Inc. account as of December 31, 2024. 2. Worksheet adjustments (consolidation journal entries) for the December 31, 2024, consolidation of Galvin and Goldberg. 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 to include in your solution? You can use the as a template to complete the assignment. Alternatively, you can build your own Excel solution from scratch and the following are suggestions of items to include if you choose that option: - Acquisition Date Allocation including the calculation of any amortization. award if you make mistakes. - Equity Income for each year (these are needed to help arrive at the investment balance). - Investment in Goldberg - Consolidation entries - I also recommend having a small section somewhere in the worksheet with "given" information so that any formulas you use can pull from it (Goldberg's income and dividends, etc.). Consolidation Project - Excel Case Study - Guide Acquisition Date Allocation Consideration transferred Goldberg Common Stock Goldberg Retained Earnings Cost over book Account Given Amount Formula LivenLifeFormulaAmort Inventory Goldberg sells to Galvin 2023 2024 Remaining Given Given Intra-entity Inventory Transfers Equity in Goldberg, Inc. Earnings 2023 Reported Net Income Formula El profit Formula Amortization Equity earnings Formula Formula 2024 Reported Net Income Formula Bl profit: El profit Amortization Equity earnings Goldberg, Inc, Dividends 2023 Given 2024 Given Goldberg, Inc. Income 2023 Given 2024 Given Formula Formula Formula Formula - The amounts labeled "given" are provided in the case study and will just be entered into the spreadsheet. - The cells labeled "formula" should include formulas. They can be as simple as "=H20" for the 2023 reported net income in the calculation of Equity in Goldberg Earnings. That formula is just pulling a number from somewhere else in the spreadsheet. Or, it could be more complicated and include references to other cells and have mathematical operations like the formula at the end of the consolidation entries that will calculate whether the investment account goes to zero or not
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started