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

1. entering the consolidation entries in the appropriate columns for the elimination entries [E], and the addition of the AAP amounts [A]; and,
2. 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]