please help !!

Consolidation spreadsheet for continuous sale el inventory method Automaty na 200 The purch 150.000 tonnes of the door of Scient to win Original AAPA The with the team of The Game , furth year way ocala $a 9 VIME Showie tyd the precondition to income from tyported by the parents with what Internet 12. ITE Il Show the computation to your enthousind the parenta December 2011 then we were DOY c. Prepare the codation journal arts foche ended December 11, 2013 Decor De LE Cri RO $ Support Business Course Return to course Grohe year en Decome Consolidation Worksheet Description Debi Crede 10 Dudent 1 To Com 500 $22.00 Goodwill 100 000 Open 000 OV 100 17,00 12. O 0 D 1251 Dell Code worau Cloud Do M Business Course tanto con Support ou are the consolidation trashet for the year ended December 21, 2013. Hinter with a wa minat me Parent Consolidated Inc 09 H37000 3700 0. 1910 1467.50 8.000 311.000 * 19 000 11100 MS Stretinere 11 10 215009 17 AIR co Balance she 2 DO 2 HP LOM 000 IAL JAL 12.30 1300 0 150 M 2000 ME tot A GOV * 1 135408 15656 5530 347,780 407E084 SEEEEE X FE lvl M M fal 27,200 19.380 po 5.000 16.500 13500 1903726 71316 051.734 U. 15.000 75.000 100.000 5.000 122.500 87.500 100.000 12507 TA) TA Royalty groot lal Met LES Top IC AO 525 2.000 CS A 000SEE Iedel 0 NO 1 O WEBOM 57.00472 SL100 Liabilities and stockholders equity Borsable 512733 Others 127 mate 2.500.000 51.000 710495 52200 MC 51 6520 dang 2.617.8 WOH51.100,771 0. O MO SILES IE TE 0 O O 16005 $ Us Check Mob.00 Consolidation spreadsheet for continuous sale of inventory.gulty method in the parent company residur eru upurchase pre was 2.300.000 hesthe two the whose following Am MAPA THE 1 There with freebied in the heart to Acume that the parent company has encovy o wywned study. The under the contenero de toward post 2012 Rama try well Sales Inventory 11 2001 The emanet of the other the whole The te pare and store year December 2011, partito Show the commutation to yet the recomanda como tam while ported by the parent comme le regard with when apprent PA 11 12. Show the contion to yield te luty sent by enter 31,2011. 200 ARE VO DAE the con una for the your ended December Canton Belor D 10 aces 0 . . O 0 0 c. Prepare the consolidation journal entries for the year ended December 31, 2013. Consolidation Worksheet Description Debit Credit [C Income (loss) from subsidiary 69,837 x 0 Dividends 14,251 Equity investment 0 53,586 x [E] Common stock 52,200 0 APIC 65,250 0 BOY retained earnings 404,550 Equity investment 0 522,000 IA PPE net 85,000 Customer list 122,500 x 0 Royalty agreement 87,500 x Goodwill 100,000 Equity investment 0 395,000 [D] Operating expenses 35,000 PPE net 0 5,000 Customer list 0 17,500 x Royalty agreement 0 12.500 x [lcogs] Equity investment 12,597 x Cost of goods sold 0 12,597 x To recognize deferred profit on prior year's sale. [lsales) Sales 68,000 Cost of goods sold 68,000 19,380 x 0 [lcogs) Cost of goods sold 0 Inventory 19,380 x To defer gross profit on the intercompany sale. 27,200 x 0 [lpayl Accounts payable Accounts receivable 0 27.200 x . . E Business Course Return to course Support d. Prepare the consolidation spreadsheet for the year ended December 31, 2013. Mint Use negative signs with answers when appropriate Elimination Entries Parent Sub DY Consolidated Income statement Sales 54,70.000 $714.000 2000 SCOS DU Cotos 0001 19.580 13. O 1467 000 Gross pro 1311.000 314200 LA come from diary G GO ID 000 1060 SSS S100 SES Statement of retained earnings One 1. SADA550 JE 2198 110620 SA IEEGA 11425 1 LOY 617161 1900:519 Balance sheet 05 01726 Cash Albo wetry SAR 1154 24 D COMILOSA 2014 27200 19.30 000 500 100 Cases DOO 5.000 00 2.500 10.000 12 101 101 IN AL 52000 E1 104550 Not income Statement of retained earning SOT and Netico Dividende Orderings Balance sheet 52.195,288 5404550 549937 110.000 122.194 126177061350019 SZY 14251 SER 126.164 32617.8 5254057 ch As receivable tory SUSA 550360 347.780 40084 111316 1.06.14 PEET 27.200 ml 19.10 1.000 10 Y. M M 165.00 10 tal lol K BOSE tal IA A A A Del Customers Royalty Goodit Louity investment 15.000 122.500 7:50 100.000 12.07 100.000 958 889 10 2000 . 000 M 7094752 11.100721 Liabilities and stockholders'equity Accounts payable Oder is D NO 1 22 2.500.000 7141 1223 1.000 2.300 DO 10 OX Cam AC and earning al 0 2.6171 60 51.10077 NO Consolidation spreadsheet for continuous sale el inventory method Automaty na 200 The purch 150.000 tonnes of the door of Scient to win Original AAPA The with the team of The Game , furth year way ocala $a 9 VIME Showie tyd the precondition to income from tyported by the parents with what Internet 12. ITE Il Show the computation to your enthousind the parenta December 2011 then we were DOY c. Prepare the codation journal arts foche ended December 11, 2013 Decor De LE Cri RO $ Support Business Course Return to course Grohe year en Decome Consolidation Worksheet Description Debi Crede 10 Dudent 1 To Com 500 $22.00 Goodwill 100 000 Open 000 OV 100 17,00 12. O 0 D 1251 Dell Code worau Cloud Do M Business Course tanto con Support ou are the consolidation trashet for the year ended December 21, 2013. Hinter with a wa minat me Parent Consolidated Inc 09 H37000 3700 0. 1910 1467.50 8.000 311.000 * 19 000 11100 MS Stretinere 11 10 215009 17 AIR co Balance she 2 DO 2 HP LOM 000 IAL JAL 12.30 1300 0 150 M 2000 ME tot A GOV * 1 135408 15656 5530 347,780 407E084 SEEEEE X FE lvl M M fal 27,200 19.380 po 5.000 16.500 13500 1903726 71316 051.734 U. 15.000 75.000 100.000 5.000 122.500 87.500 100.000 12507 TA) TA Royalty groot lal Met LES Top IC AO 525 2.000 CS A 000SEE Iedel 0 NO 1 O WEBOM 57.00472 SL100 Liabilities and stockholders equity Borsable 512733 Others 127 mate 2.500.000 51.000 710495 52200 MC 51 6520 dang 2.617.8 WOH51.100,771 0. O MO SILES IE TE 0 O O 16005 $ Us Check Mob.00 Consolidation spreadsheet for continuous sale of inventory.gulty method in the parent company residur eru upurchase pre was 2.300.000 hesthe two the whose following Am MAPA THE 1 There with freebied in the heart to Acume that the parent company has encovy o wywned study. The under the contenero de toward post 2012 Rama try well Sales Inventory 11 2001 The emanet of the other the whole The te pare and store year December 2011, partito Show the commutation to yet the recomanda como tam while ported by the parent comme le regard with when apprent PA 11 12. Show the contion to yield te luty sent by enter 31,2011. 200 ARE VO DAE the con una for the your ended December Canton Belor D 10 aces 0 . . O 0 0 c. Prepare the consolidation journal entries for the year ended December 31, 2013. Consolidation Worksheet Description Debit Credit [C Income (loss) from subsidiary 69,837 x 0 Dividends 14,251 Equity investment 0 53,586 x [E] Common stock 52,200 0 APIC 65,250 0 BOY retained earnings 404,550 Equity investment 0 522,000 IA PPE net 85,000 Customer list 122,500 x 0 Royalty agreement 87,500 x Goodwill 100,000 Equity investment 0 395,000 [D] Operating expenses 35,000 PPE net 0 5,000 Customer list 0 17,500 x Royalty agreement 0 12.500 x [lcogs] Equity investment 12,597 x Cost of goods sold 0 12,597 x To recognize deferred profit on prior year's sale. [lsales) Sales 68,000 Cost of goods sold 68,000 19,380 x 0 [lcogs) Cost of goods sold 0 Inventory 19,380 x To defer gross profit on the intercompany sale. 27,200 x 0 [lpayl Accounts payable Accounts receivable 0 27.200 x . . E Business Course Return to course Support d. Prepare the consolidation spreadsheet for the year ended December 31, 2013. Mint Use negative signs with answers when appropriate Elimination Entries Parent Sub DY Consolidated Income statement Sales 54,70.000 $714.000 2000 SCOS DU Cotos 0001 19.580 13. O 1467 000 Gross pro 1311.000 314200 LA come from diary G GO ID 000 1060 SSS S100 SES Statement of retained earnings One 1. SADA550 JE 2198 110620 SA IEEGA 11425 1 LOY 617161 1900:519 Balance sheet 05 01726 Cash Albo wetry SAR 1154 24 D COMILOSA 2014 27200 19.30 000 500 100 Cases DOO 5.000 00 2.500 10.000 12 101 101 IN AL 52000 E1 104550 Not income Statement of retained earning SOT and Netico Dividende Orderings Balance sheet 52.195,288 5404550 549937 110.000 122.194 126177061350019 SZY 14251 SER 126.164 32617.8 5254057 ch As receivable tory SUSA 550360 347.780 40084 111316 1.06.14 PEET 27.200 ml 19.10 1.000 10 Y. M M 165.00 10 tal lol K BOSE tal IA A A A Del Customers Royalty Goodit Louity investment 15.000 122.500 7:50 100.000 12.07 100.000 958 889 10 2000 . 000 M 7094752 11.100721 Liabilities and stockholders'equity Accounts payable Oder is D NO 1 22 2.500.000 7141 1223 1.000 2.300 DO 10 OX Cam AC and earning al 0 2.6171 60 51.10077 NO