Using the data in theattached spreadsheet, complete the consolidation worksheet by entering the consolidation entries in the appropriate columns for the elimination entries E , and the addition of the AAP amounts A and, b)preparing the consolidated balance sheet as it would appear after acquisition Requirements Clearly identify the requirements being addressed Show all calculations within the cells of an Excel spreadsheet This means that you must use formulas and links so that the thought process can be examined Make good use of comments to convey your thought process as well No hard coding of solutions j ACT n Studentpread skeet Mandi CT Dptin D I E Candi u E Farmer I Number Ea CaFI St c D Madule 1 aptlun 2 5mm Par em 15 IJabthles and I ' 1 Etndmulders' equity I 15 DIITEM Llablliu 19 mim Hahiies In Band payable 11 Cumrmn stand 12 APIE 13 Rehlnad earnings 14 Tara 25 15 1 Parent 1me purd'lased Suhsldlarvm Illinfnr lel The parent pald mun man bunkvahe dueta mum valued 23 P'l'E organ and an Lmremrded swam patent valued at 50 13am 19 Ell

The Answer is in the image, click to view ...

Question: Using the data in theattached spreadsheet, complete the consolidation worksheet by: entering the consolidation entries in the appropriate columns for the elimination entries [E], and

Using the data in theattached spreadsheet, complete the consolidation worksheet by:

entering the consolidation entries in the appropriate columns for the elimination entries [E], and the addition of the AAP amounts [A]; and,
b)preparing the consolidated balance sheet as it would appear after acquisition.

Requirements

Clearly identify the requirements being addressed.
Show all calculations within the cells of an Excel spreadsheet. This means that you must use formulas and links so that the thought process can be examined. Make good use of comments to convey your thought process as well. No hard coding of solutions.

Using the data in theattached spreadsheet, complete the consolidation worksheet by:entering the

j ACT-n Studentpread-skeet Mandi\" CT Dptin D I [E| Candi: /u E? Farmer ~+ I Number Ea: CaFI St . c D . Madule 1- aptlun 2.5mm! _._ _ __ Par-em _ 15 IJabthles and I ' 1? Etndmulders' equity I 15 DIITEM Llablliu 19 mim- Hahiies In Band: payable 11 Cumrmn stand. 12 APIE 13 Rehlnad earnings 14 Tara! 25 15 1? Parent [1me purd'lased Suhsldlarvm Illinfnr lel. The parent pald mun! man bunkvahe dueta mum-valued 23 P'l'E organ and an Lmremrded swam patent valued at 50.13am __ 19 ________ Ell]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Assignment Option #1: Acquisitions with Ownership = 100% and BV = FMV Using the data in the Option 1 Spreadsheet (linked at the bottom of the page), perform the accounting required for the...

Consolidation spreadsheet for continuous sale of inventory - Equity method Assume that a parent company acquired a subsidiary on January 1, 2010. The purchase price was $500,000 million in excess of...

I need help Consolidation spreadsheet for continuous sale of inventory - Equity method Assume that a parent company acquired a subsidiary on January 1, 2010. The purchase price was $500,000 million...

here he the first picture again Consolidation spreadsheet for continuous sale of inventory. Equity method Assume that a parent company acquired a subsidiary on January 1, 2016. The purchase price was...

Purpose Several methods to record investments in other companies were discussed in this course. The method selected depends upon the degree of influence the investor has over the investee....

Using the data in the attached spreadsheet, complete the consolidation worksheet by: entering the consolidation entries in the appropriate columns for the elimination entries [E], and the addition of...

here are the information in a tabular form Purpose Several methods to record investments in other companies were discussed in this course. The method selected depends upon the degree of influence the...

Hi tutors, Pls help me to answer the excel project. I need the formula in the excel row not just the number only. Pls find the attachment as my project. In the question tab I just need the 2 yellow...

Detective analysis-identify company Effective financial statement analysis requires an understanding of a firms economic characteristics. The relations among various financial statement items provide...

An individual begins employment on December 16, 20X0. The employer pays salaries monthly on the 15th day of each month. The individual receives her first salary payment of $3,000 on January 15, 20X1....

In any purchasing or selling transaction, a client has the option to submit two categories of orders. Distinguish between limit orders and market orders by using relevant examples

Identify what elements / topics must be included in employee training in HAZCOM: Identify what elements / topics must be included in employee training in HAZCOM: Operations in work areas where...

1. Within the walls of a sterile prison Vickie Stringer began changing her life. Describe what mental processes were available to her in this environment.

2. Explain how the Self-Talk Endless Loop in Figure 4.1 can help individuals like Vickie Stringer.

The financial area of your life: Where are you living? In what type of home? How much money do you have in savings and investments? What kind of car are you driving?