Graded ASSignmem :'rilldentpling ZU'iB , EKEEI Muhammad Naha; E Formulas Dara REVIEW Vrew FonitPDF PDwel'Pll/ut ', : rnlnrn '1; Share a. m I. r._.. . 38cm Callhll . 12 EfWrapTexl Genelal . 4 Normal Bad (m 3x j )ZmrtoSurn AY p E'g Copy . 3' ~ EE' EE' El Fillv 2 Past 1 u . 4 v H MefgeglCente, 7 $ . % , 53 \".3 Conditronal Format as sand Neutral 7 Insert Delete Format SOI'IBL FilldBL ~ 'mea'l'a'me' ' Formattrngv Table . v " Gear Flltelv Selectv Cilpbaard a Font n Aiignmem K. Number n Slyies CeHs Edmng A A2 v - f, A A A i B C i D i E i F i G i H i I i J i K i L i M i N i 0 i P i Q i R i s i T A Part D - Consolidation Journal Entries for 2018 H Account DR CR 'w'm'u'm'm A'w 'o' WWWimiaigiaigiiialaiiiiim Par'tA PadB Par'tC ParlD Par'tE' (.9 54 ' Ready Graded ASSignmem :'rilldentpling 2mg , EKEEI Muhammad Naha; E Formulas Data REVIEW View FonitPDF PDwel'Pll/ut ', : inlnrn '1; Share a. m m i._n . as cut Callhll EleapTexl Genelal . .4 \"(mar Bad (.m EEK 2H )2 Autosirrn QY 9 E9 Copy . 3' ~ EE' El Fill . Paste ' 5 I H . H Mefgeleente, 7 $ . % , 53 3 Conditional Formatas 500d Neutral 7 Insert Delete Format .Clear' SOI'IBL FilldBL v mea' Pa'mer Folmattlllg v Table . v ' Flltel v Select . clipboard a Font n Alignment K. Number n Slyies cells Edmng A A1 v 5 fr Part E , Consolidation Journal Entries For 2017 A A B l C | D l E i F | G l H | | l J | K i L | M l N | 0 l P | Q l R | S l T | L A Part B Consol a on Journal Ent_ as for 2017 Account DR C R Par'tA Part3 Par'tC ParlD Par'tE' (.9 E4 ' Ready E Graded ASSignmem :'Ludentiipiing 2mg , Extel Muhammad Malia; E Page Layout Formulas Data Revuew View Foxit PDF PDwei'Pivot mom '1; Share it as\" TimesNewRoi' 12 EfWIapTexl Cnsinm . .4 A (Tm ESx \"i" EAutoSum . AY p Pat EBCOW' a nu c d: IF I . FERDEII F t Eln. SiBLFdBL - . 53 Wm B I u . : H MW $ '% , m \"min: 23:\" Comm Cam n "S? fe gm. Ciipbaard a Font n Aiignmem '2 Number n Slyies ceiis Edmng A BB v E f; A A A isicIDiE F GHI J|K iM Nio PIQiRiSiTiA ZiLaIld 160.250 110.000 2: Equipment net 151,000 975% 2: Buildings net 347,500 192'700 23 Investment in Robert 2L 21 21 33 . 3i _ 3; SiTotal Assets 661(800 - 3i Si Accounts Payable (92.600) (64.200) 33 Notes Payable (225.785) (94600) 31 Common Stock (422,500) (121000) 31 Additional PIC (535,700) @5000) 39 Retained Earnings (12/31) (333.000) 43 Liabilities and Equity (6613900) '1 ENoncontIoLling Inte1est 1/1 43 Dnlvth: Veilow miss 7 aboveneedmbe 44 :omnieled hvyun, 41 Noncorm'olling IHIBTESI 12/31 43 _ _ _ 41 49 V Par'tA PadB PartC ParlD Par'tE ' GD . 4 0 Ready E E -|+ 95% PagE Layout Formula; Data REVIEW VIEW FDKit PDF PDWE!' Plvut mEmSinudEntiipling 2mg 7 EXCEI MDhammEd Naha; E .3. SharE \"- ag\" TimesNewRo1'12 ~ A' A' * w~ EfWrapTexl Custom . ,4 ' (CECE- EEK \"in 2mm\" ' AY 9 Pat EECOW' a nu c a: IF I . IEEln Dill F t Eln. SiBLFdBL - n , n . f Mammler I u . 4' &.A. 7 7 7 HMefgesicemeI v $ .% , m ..a \"Egg; :3ng Comma Comma [0] "size vee orma 'kleap \"ravaged. Chpbaard r. Font r. Allgnmem a Number V. Slyles ceus Edmng A BB v E f; A A A lBlCID'E'F GlHlllJIK lMlNlOlPIQ'R'S'T'A L Pan C - Cnnsolidninn Wnrkshaat [or 2017 [These should link\": Part B] L Brady Robert Worksheet entries Consolidated 1 12/31/2017 12/31/2017 DR CR Balances Llncame Statement L Revenues (1.050.000) (615.000) 6 Expenses 725.000 422.000 L Operating Income 325.000) (193.000) iEquityIncome 'ornRoben _ - 9 NoncontIolling interest share 13 Controlling share of net income (193.000) - 117 1; Retained Earnings Statement 11 Beginning Remined Earnings (685.000) (215.000) 1: (Controlling share)Net Income (193.000) 15 Dividends Paid 105.000 75.000 13 11 Ending Retained Eamings (333.000) - 11 1; Balance Sheet 21 Cash 85.450 85.000 217 Inventory 106.2 00 84.600 2; Accounts receivable 142.185 92.000 ZiLand 160.250 110.000 2: Equipment. net 151.000 97.500 23 Buildings. net 347.500 192.700 Aluvestmentinkqhert ' ' Par'lA ' PadB PartC ParlD Par'tE ' GD 4 b E E -|+ 95% Ready qnmentSinudentgpling 201a , Extel Mohammad Naha; PageLayouI Formulas Data Review View FoxitPDF PowerPIvot uammm ,1; Share 1H. it as C'" Times New Row 12 EfWIapTexl Custom . a A (TE. x )2 AutoSum . AY Paste EB cow . B I ll - M .u an Condit1:nal Formal as C C D . Elem Sale Finer El H\" . sin BL Fl v " mea' Pa'mer _ v 4 V H age SrCentel 7 $ ' % y M m Formattmg v Table omma omma [ I 7 . v v 'O Clea" Flltel' Selectv Chpbaard a Font n Mgnmem a Number n was CeHs Edmng A 1333 v E f; 7536700 A A A B|C1D1E F GHI J1K1L1M1N0PQA L Part E - Consolidation Worksheet for 2015 [these should link (a Part D] L Brady Robert Worksheet entries Consolidated 37 12/31/2018 12/31/2018 DR CR Balances 4_ Income Statement iRevenues (1,200,700) (575,000) 6 Expenses 936,000 425,000 L Operating Income (264,700) (150,000) 87 Equity Income from Robert - 9 Noncontrolling interest share 13 Controlling share of net income (150,000) 117 1; Retained Earnings Statement 11 Beginning Retained Earnings (333,000) 1: (Controlling share) Net Income (150,000) 15 Dividends Paid 110,000 50,000 11 1L Ending Retained Earnings (433,000) 1i 1; Balance Sheet 20 Cash 102,900 89,200 ZLInventory 146,300 114,600 2; Accounts receivable 86,200 101,000 23 Land 160,250 146,750 7 'Par'lA ' ParlB ' Par'lC ParlD PartE GD 5 4 b a E |+ 10795 Ready qnmemSinudentiipling 2mg , EKCEI Muhammad Naha; PageLayqu Formulas Data Remew VIEW FDKitPDF PDwerPIvut wanlmco ,1; Share it as\" TimesNeme' 12 EfWIapTexl Custom . a A (TE. ESx 'H' EAutoSum . AY Paste EECOW . B I ll - M .u an Conditiimal Formalas C C D . Eli\" Sale Finer Eln. Sinai Fl v 'FormalPamter _ v 4 V H ngSlcenteI 7 $ ' % y M m Folmattmgv Table omma omma[ I 7 . v v \\'Clearv FIIterSelect' cupboard a Font n Alignment a Number n Slyles ceus Edmng A 333 v E f; 753670!) A A A lBlC'D'E F GHI J'K'L'M'N'O'P'Q'A 23 Land 160,250 146,750 2: Equipment, net 225,350 153,270 21 Buildings, net 460,800 224,000 21 Investment in Ruben 2L 2i 29_ 30 317 3; a Total Assets 828,820 31 3i Accounts Payable (110,500) (85,200) 33 Notes Payable (202,400) (140,620) 3 Common Stock 422,500 (125,000) i AdditionalPIC (536,700)_ (45,000) 39 Retained Earnings (12/3 1) (433,000) 41 Liabilities and Equity (828,820) 41, 4i Noncontrolling Interest 1/1 SSLVV:1:::\":';L:\"' 41 completed by you. 4i 45 Noncontrolling Interest 12/31 v ' Par'lA ' ParlB ' Par'lC l ParlD PartE GD 5 4 p Ready E E |+ 107% Graded ASSignmem :'rilldentpling 2mg , EKEEI Muhammad Naha; E Formulas Dara Revrew Vrew FuxitPDF PDwel'Pll/ut 7, : 'MIDED 2'1 snare a. m I. r._.. . 330" Callhll .11 EfWrapTexl General . ,4 Normal Bad (-EEI EEK 3' 2mm\" QY 9 E9 Copy . 3' ~ EE' El Fillv Pa 1 1 ll . : . H Memeslc, 7 $ . % , Mg mg Conditlonal Folmalas 500d Neutral 7 Insert Delete Format SonBL FindBL ~ 'mea'l'a'me' ' Formamngv Table . v ~ " Gear Fllteleelectv Chpbcard a Font n Allgnmem K. Number n Slyles CeHs Edmng A Bl v - f, A \\ D \\ E I F \\ G \\ H \\ I \\ J \\ K \\ L \\ M \\ N \\ O \\ P \\ Q \\ R \\ S \\ T \\ U \\ V \\ ' al purchele price Investment Accoun! balance cn Brady's bank: Beginning Balance , Balince 12/31/2011 16 Balance 12/31/2018 20 Important to sh aw the detaii of your calculaticns atmve. ParlA PadB Par'tC ParlD Par'tE' (.9 E4