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)
Consolidation Worksheet Accounts Prairie View Stony Harbor Eliminations Consolidated Totals Revenues ... 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
-
51.Merchants, Inc. sells Product X to retailers for P200. The unit variable cost is P40 with a selling commission of 10%. Fixed manufacturing cost totals P1,000,000 per month, while fixed selling and...
-
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.
-
Write the converse and the contrapositive to the following statements. (a) If I get an A on the final exam, I will pass the course. (b) If I finish my research paper by Friday, then I will take off...
-
A firm employs an average of 8,600 workers. Each year, the firm must replace 900 workers due to turnover. What is the employee turnover (in percent)?
-
Discuss differences between private inurement and private benefit. Why do nonprofit organizations need to differentiate between these two concepts?
-
Gore had been the owner of 1 percent of the outstanding shares of the Webster Company, a corporation, since its organization ten years ago. Ratliff, the president of the company, was the owner of 70...
-
Explain the following financial tools used for control. Include an explanation of each of their value in business planning. financial statements balance sheet income statement audits (internal and...
-
The relief time provided by a standard dose of a popular children's allergy medicine averages six hours with a standard deviation of two hours. a. Determine the percentage of children who experience...
-
What is the % w/v of an isotonic solution for morphine sulphate (FD 1% = 0.079)? A. 6.58 B. 9.28 C. 5.36 D. 11.4 2 What mass (g) of sodium chloride (FD 1% = 0.576) is required to make 18 mL of the...
-
In the figure, the particles have charges 91 = -92-867 nC and 93 = -94 = 90.7 nC, and distance a = 5.27 cm. What are the (a) x and (b) y components of the net electrostatic force on particle 3? 3
-
Write a Java program that searches a sorted list of n items by dividing it into three sublists of almost n/3 items. The algorithm finds the sublist that might contain the given item and divides it...
-
Carlos purchased a new business asset (five-year property) on February 10, 2023, at a cost of $100,000. Carlos did not elect to expense the asset under 179 and did not elect straight-line cost...
-
a) Write a class Student that define the following information: name, stid, age. b) Explain a mutators (setters) and accessors(getters) methods for each attributes(fields). c) Add three constructors:...
-
Find the inverse of the one-to-one function f and then graph both f and fon the same set of axes. f(x)=3x-5
-
AB, CD are solid shafts made of the same material with shear modulus (70 + x) GPa. Radius of the shafts AB, CD are the same rAB = rCD = 20 mm. Radius of gear B rg = 100 mm. Radius of gear C rc = 40...
-
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...
-
Describe a conflict that may arise between the shareholders of a company and the debtholders of the company. Discuss what the debtholders might do to resolve that conflict and explain why you feel...
-
Describe a conflict that may arise between the shareholders of a company and the managers of the company. Discuss what the shareholders might do to overcome that conflict and explain why you feel...
-
Ernst & Young, LLP is the independent public accountant for AMR Corporation, the parent company of American Airlines and American Eagle. In February 2013 AMR and US Airways Group announced the two...
Study smarter with the SolutionInn App