This tab contains details needed for the project. Formulas are highlighted in gray. When completing the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
This tab contains details needed for the project. Formulas are highlighted in gray. When completing the different parts, link all cells. No cells should be hard coded. Do not fill in or change anything on this tab. All work will be completed on subsequent tabs. PROJECT FACTS Ownership (no dissolution) Acquisition Date Consideration (paid in cash) Fair value of NCI 80% Stony Harbor Balance Sheet 1/1/2023 Assets 1/1/2023 Cash $ 396,000 Accounts Receivable $ 99,000 Inventory Land Equipment (net) STONY HARBOR FAIR VALUES AT ACQUISITION Software (net) Equipment (5 year remaining useful life) $ 105,000 Total Assets Software (3 year remaining useful life) $ 28,000 Customer list (10 year useful life - currently unrecognized) $ 45,000 Liabilities INTRAENTITY TRANSACTIONS Prairie View sold Land to Stony Harbor on 1/2/2024. They still hold the land at the end of 2024. Common Stock Sale Price $ 38,000 Additional Paid-in Capital Book Value $ 30,000 Retained Earnings Total Liabilities and Equity 41,700 95,600 185,200 46,000 85,000 25,000 478,500 Liabilities and Equity 102,500 20,000 205,000 151,000 478,500 Stony Harbor sold inventory to Prairie View in 2024. Sales price $ 66,000 STONY HARBOR'S RETAINED EARNINGS CHANGES Cost $ 52,000 2023 Income $ 45,000 Gross Profit % 21% 2023 Dividends $ 12,000 % Remaining at yearend 25% 2024 Income $ 43,000 2024 Dividends $ 16,000 Prairie View owes Stony Harbor at the end of 2024 $ 20,000 Acquisition Journal Entry DR CR Investment in Stony Harbor Cash $ 396,000.00 $ 396,000.00 Fair-Value Allocation Schedule Total Fair Value Book Value Excess Initial Value $ 495,000.00 $ (376,000.00) Useful Life $ 119,000.00 to Equipment to Software to Customer List to Goodwill Goodwill Allocation Schedule $ $ $ $ 20,000.00 $ 3,000.00 $ 45,000.00 $ 51,000.00 Amortization 5 $ 4,000.00 3 $ 1,000.00 10 $ 4,500.00 CI NCI Total 396,000.00 $ 99,000.00 $495,000.00 355,200.00 $ 88,800.00 $444,000.00 40,800.00 $ 10,200.00 $51,000.00 $ 9,500.00 Initial investment, 1/1/23 Dividends Income of Stony Harbor Amortization Investment in Stony Harbor 12/31/23 Dividends Income of Stony Harbor Amortization Deferred profit Deferred gain on sale of land Investment in Stony Harbor 12/31/24 $ 396,000.00 $ (9,600.00) $ 36,000.00 $ (7,600.00) $ 414,800.00 $ (12,800.00) $ 34,400.00 $ (7,600.00) $ (2,800.00) $ (8,000.00) $ 418,000.00 Complete the consolidation worksheet below. Start by filling in the yellow squares for Prairie View's trial balance. Use formulas whenever possible (calculating values or totaling rows/columns). Make sure your debits and credits are being added/subtracted correctly. All consolidation entry values need to be linked to the trial balance or other tabs. If any additional schedules are needed, place them below the consolidation worksheet. Equity Method Consolidated Worksheet - For the Year Ended 12/31/2024 Accounts Trial Balance Prairie View Stony Harbor (JE ref) Consolidation Entries Debit || (JE ref) | Credit Noncontrolling Consolidated Interest Totals Revenues and Gains Cost of Goods Sold Operating Expenses 850,000 750,000 680,000 602,000 145,000 105,000 Income of Stony Harbor Net Income 25,000 43,000 Net Income attributable to NCI Net Income attributable to Prairie View Retained Earnings - Prairie View 1/1 1,074,605 Retained Earnings - Stony Harbor 1/1 184,000 Net Income (above) 25,000 43,000 Dividends Declared 95,000 16,000 Retained Earnings 12/31 1,004,605 211,000 Cash 156,000 115,490 Accounts Receivable 305,000 93,250 Inventory 595,000 160,750 Investment in Stony Harbor Land Equipment (net) Software (net) Customer List Goodwill 125,000 84,000 463,580 51,000 59,375 19,000 Total Assets 1,703,955 523,490 Liabilities 451,350 87,490 Common Stock 50,000 20,000 Additional Paid-in Capital 600,000 205,000 Noncontrolling Interest in Stony Harbor, 1/1 Noncontrolling Interest in Stony Harbor, 12/31 Retained Earnings (above) 1,004,605 211,000 Total Liabilities and Equity 2,105,955 523,490 (402,000) This tab contains details needed for the project. Formulas are highlighted in gray. When completing the different parts, link all cells. No cells should be hard coded. Do not fill in or change anything on this tab. All work will be completed on subsequent tabs. PROJECT FACTS Ownership (no dissolution) Acquisition Date Consideration (paid in cash) Fair value of NCI 80% Stony Harbor Balance Sheet 1/1/2023 Assets 1/1/2023 Cash $ 396,000 Accounts Receivable $ 99,000 Inventory Land Equipment (net) STONY HARBOR FAIR VALUES AT ACQUISITION Software (net) Equipment (5 year remaining useful life) $ 105,000 Total Assets Software (3 year remaining useful life) $ 28,000 Customer list (10 year useful life - currently unrecognized) $ 45,000 Liabilities INTRAENTITY TRANSACTIONS Prairie View sold Land to Stony Harbor on 1/2/2024. They still hold the land at the end of 2024. Common Stock Sale Price $ 38,000 Additional Paid-in Capital Book Value $ 30,000 Retained Earnings Total Liabilities and Equity 41,700 95,600 185,200 46,000 85,000 25,000 478,500 Liabilities and Equity 102,500 20,000 205,000 151,000 478,500 Stony Harbor sold inventory to Prairie View in 2024. Sales price $ 66,000 STONY HARBOR'S RETAINED EARNINGS CHANGES Cost $ 52,000 2023 Income $ 45,000 Gross Profit % 21% 2023 Dividends $ 12,000 % Remaining at yearend 25% 2024 Income $ 43,000 2024 Dividends $ 16,000 Prairie View owes Stony Harbor at the end of 2024 $ 20,000 Acquisition Journal Entry DR CR Investment in Stony Harbor Cash $ 396,000.00 $ 396,000.00 Fair-Value Allocation Schedule Total Fair Value Book Value Excess Initial Value $ 495,000.00 $ (376,000.00) Useful Life $ 119,000.00 to Equipment to Software to Customer List to Goodwill Goodwill Allocation Schedule $ $ $ $ 20,000.00 $ 3,000.00 $ 45,000.00 $ 51,000.00 Amortization 5 $ 4,000.00 3 $ 1,000.00 10 $ 4,500.00 CI NCI Total 396,000.00 $ 99,000.00 $495,000.00 355,200.00 $ 88,800.00 $444,000.00 40,800.00 $ 10,200.00 $51,000.00 $ 9,500.00 Initial investment, 1/1/23 Dividends Income of Stony Harbor Amortization Investment in Stony Harbor 12/31/23 Dividends Income of Stony Harbor Amortization Deferred profit Deferred gain on sale of land Investment in Stony Harbor 12/31/24 $ 396,000.00 $ (9,600.00) $ 36,000.00 $ (7,600.00) $ 414,800.00 $ (12,800.00) $ 34,400.00 $ (7,600.00) $ (2,800.00) $ (8,000.00) $ 418,000.00 Complete the consolidation worksheet below. Start by filling in the yellow squares for Prairie View's trial balance. Use formulas whenever possible (calculating values or totaling rows/columns). Make sure your debits and credits are being added/subtracted correctly. All consolidation entry values need to be linked to the trial balance or other tabs. If any additional schedules are needed, place them below the consolidation worksheet. Equity Method Consolidated Worksheet - For the Year Ended 12/31/2024 Accounts Trial Balance Prairie View Stony Harbor (JE ref) Consolidation Entries Debit || (JE ref) | Credit Noncontrolling Consolidated Interest Totals Revenues and Gains Cost of Goods Sold Operating Expenses 850,000 750,000 680,000 602,000 145,000 105,000 Income of Stony Harbor Net Income 25,000 43,000 Net Income attributable to NCI Net Income attributable to Prairie View Retained Earnings - Prairie View 1/1 1,074,605 Retained Earnings - Stony Harbor 1/1 184,000 Net Income (above) 25,000 43,000 Dividends Declared 95,000 16,000 Retained Earnings 12/31 1,004,605 211,000 Cash 156,000 115,490 Accounts Receivable 305,000 93,250 Inventory 595,000 160,750 Investment in Stony Harbor Land Equipment (net) Software (net) Customer List Goodwill 125,000 84,000 463,580 51,000 59,375 19,000 Total Assets 1,703,955 523,490 Liabilities 451,350 87,490 Common Stock 50,000 20,000 Additional Paid-in Capital 600,000 205,000 Noncontrolling Interest in Stony Harbor, 1/1 Noncontrolling Interest in Stony Harbor, 12/31 Retained Earnings (above) 1,004,605 211,000 Total Liabilities and Equity 2,105,955 523,490 (402,000)
Expert Answer:
Answer rating: 100% (QA)
Detailed Explanation To proceed with calculations you would generally follow these steps Prepare Acquisition Journal Entries Record the acquisition of Stony Harbor by debiting Investment in Stony Harb... View the full answer
Related Book For
Understanding Financial Statements
ISBN: 978-0133874037
11th edition
Authors: Lyn Fraser, Aileen Ormiston
Posted Date:
Students also viewed these accounting questions
-
Write a project management plan. we have a template and project description. we need to edit the template(table of contents) with our own ideas. CPSC 8820-01 Project Management Plan Your Unique...
-
A shopping cart consists of various items. An item can be either a household or an electronic item. The following UML diagram represents item, household item, electronic item and their relationship....
-
True or False The slope of the line 2y = 3x + 5 is 3.
-
What are vision and mission? What is their value for the strategic management process? Discuss.
-
In order to use substitution, a function and its derivative (disregarding any constant multiplier) must be present in the integral. Determine whether each statement is true or false, and explain why.
-
List three ways to get input from the console and convert that input to the desired data type.
-
Based on the following graph (which summarizes the demand, marginal revenue, and relevant costs for your product), determine your firm??s optimal price, output, and the resulting profits for each of...
-
Define what is meant by an asset and a liability. Give an example of each.
-
Consider a hypothetical metal that has a density of 19.1 g/cm, an atomic weight of 218.7 g/mol, and an atomic radius of 0.110 nm. Compute the atomic packing factor if the unit cell has tetragonal...
-
The financial year of R Little ended on 31 December. Annual insurance premiums were paid to the insurance brokers at the end of February, for MarchFebruary. On 31 December 2020, the balance day...
-
Lita Litigiosus has provided you with the following list of account balances as at 30 June 2022 (figure 11.35) and balance day adjustments. You have been requested to prepare an 8-column worksheet,...
-
How is a corporate form of organization superior to other forms? Why are large organizations almost invariably incorporated as companies?
-
What is the significance of the financial markets to the CFO in achieving his/her objectives? How does he/she interface with the financial markets?
-
What objectives does a company seek to achieve and why?
-
You purchased 500 shares of a stock at a price of $22.50 per share. One year later, the shares sold for $21 each. At that end of the year, a $1.50 per share dividend was paid. What is the total...
-
Find a least expensive route, in monthly lease charges, between the pairs of computer centers in Exercise 11 using the lease charges given in Figure 2. a) Boston and Los Angeles b) New York and San...
-
Prior to the financial recession in the late 2000s, some companies had built up significant cash balances. Since that time some companies have continued to increase their cash balances and...
-
The 2013 Intel Annual Report can be found at the following Web site: www.pearsonhighered.com/fraser. Using the annual report, answer the following questions: (a) Using the Intel Annual Report,...
-
The following information is available for Chemco Inc's inventories as of June 30, 2015: We used the LIFO method of valuing our inventories for approximately 40% and 44% of total inventories at June...
-
Economy Appliance Co. manufactures lowprice, no-frills appliances that are in great demand for rental units. Pricing and cost information on Economys main products are as shown on page 943. Customers...
-
Grill Master Company sells total outdoor grilling solutions, providing gas and charcoal grills, accessories, and installation services for custom patio grilling stations. Instructions Respond to the...
-
Tablet Tailors sells tablet PCs combined with Internet service (Tablet Bundle A) that permits the tablet to connect to the Internet anywhere (set up a Wi-Fi hot spot). The price for the tablet and a...
Study smarter with the SolutionInn App