Chapter 2 Excel Assignement (1) Excel AutoSave O O Search Help Review View Formulas Data Draw Page Layout File Home Insert X 10 A A 8 Wiap Tet Arial Conditional $ % F Paste A . Formatting Alignment Number Font Cipboand fi C1 H F A Problem 02-28 MARSHALL COMPANY Part a. Marshall and Tucker Consolidated Balances 7 Marshall's acquisition of Tucker represents a bargain purchase because the fair value of the net assets acquired exceeds the fair value of the consideration transferred as follows: 10 11 12 Fair value of net assets acquired Fair value of consideration transferred Gain on bargain purchase 13 14 15 16 17 Record three transactions that occurred to create the 18 business combination: 19 20 MARSHALL COMPANY General Journal Credit Debit Account 28 (To recond habioes and stock issued for Tuckor acquistion far value) 30 31 32 33 (To recond aere of orofessional foosl Given PO2-28 34 Given PO2-34 PO2-34 PO2-29 Given PO2-29 PO2-28 Select destination and press ENTER or choose Paste IO AutoSave OR) Chapter 2 Excel Assignement (1) Excel File Home Insert Draw Page Layout Formulas O Search Data Review View Help A A Arial 2 Wrap Text 10 Paste $-% Cond Forma BIU A . Clipboard Font Alignment Number fi C1 C D E 24 Account Debit Credit 25 26 27 28 30 (To record liabildes and slock issued for Tucker acquisition fair value) 31 (To record payment of professional fees) 38 (To record payment of stock issuance costs) 39 Marshall's trial balance is adjusted for the transactions (as shown in the worksheet that follows). 40 41 42 Consideration transferred at fair value Book value (assets minus liabilities or stockholders' equity) Book value in excess of consideration transferred 43 44 45 46 47 Allocation to specific accounts based on 48 49 fair value: 50 Inventory 51 Land 52 Buildings Gain on bargain purchase (excess net asset fair value over consideration transferred) 53 55 PO2-29 Given PO2-28 Given PO2-29 PO2-34 Given PO2-34 PO2-28 Select destination and press ENTER or choose Paste e Chapter 2 Excel Assignement (1) Excel AutoSave Of O Search Help Review View Insert Formulas Data Draw Page Layout File Home X 2 Wrap Text 10A A Arial Cond $ % 8 Paste A BIU Forma Number Alignment Font Cipboard C1 H E F D C A 56 Account Name Cash Balance Explanation 57 58 59 60 Receivables 61 62 63 64 65 Inventory 66 67 Land 68 69 70 71 Buildings 72 Equipment 73 74 75 76 Total Assets 77 78 Accounts Payable 79 BC 81 Long-term Liabilities 82 83 84 Common Stock 85 86 87 Additional Paid-In Capital Given PO2-28 88 Given PO2-34 Given PO2-29 PO2-29 PO2-34 PO2-28 Select destination and press ENTER or choose Paste AutoSave Chapter 2 Excel Assignement (1)- Excel File Home Insert Draw Page Layout Formulas Search Data Review View Help t0A A Arial tWp Te Paste A Conditional Foma as Cell $ %6 % Ins FomangTableSyle Cipboand Font Alignment Number Syles c1 A F G H Additional Paid-in Capital 88 90 Retained Eamings 91 92 Total Liabilities & Equity 94 95 97 98 99 Part b. Marshall and Tucker Consolidated Worksheet 100 101 102 103 104 105 106 107 108 109 110 111 112 MARSHALL COMPANY AND CONSOLIDATED SUBSIDIARY Consolidation Worksheet January 1, 2018 Marshall Tucker Company 20,000 90,000 140,000 180,000 Consolidation Entries Debit Consolidated Accounts Cash Receivables Inventory Land Company Credit Totals 270,000 360,000 200,000 Buildings (net) Equipment (net) Investment in Tucken 420,000 160,000 220,000 50,000 113 114 115 116 117 118 119 Total assets 700,000 S1410,000 $ s (150,000) Accounts payable Long-term labilities Common stock Ad dinani PO2-28 (40,000) (200,000) (120,000) Given PO2-28 PO2-29 Given P02-29 PO2-34 Given PO2-34 Select destination and press ENTERor choose Pate Pham 144 6 AutoSave (OR) Chapter 2 Excel Assignement (1)- Excel Fle Home Insert Draw Page Layout Formulas Data Search Review View Help 10 A A Arial Wp Tt Paste BIU FER Conditional Fomat as Cell FormatsingTbleStyles $-% Cipboand Font Alignment Number Styles 1 D H Part b. Marshall and Tucker Consolidated Worksheet MARSHALL COMPANY AND CONSOLIDATED SUBSIDIARY Consolidation Worksheet January 1, 2018 Marshall Company Tucker Company 20,000 90.000 140,000 180,000 220,000 50,000 Consolidation Entries Debit Consolidated Accounts Credit Totals Cash Receivables Inventory Land Buildings (net) Equipment (net) Investment in Tucker 270,000 360,000 200,000 420,000 160,000 700,000 Total assets $1,410,000 $ (40,000) (200,000) (120,000) Accounts payable Long-term liabilities Common stock (150.000) $ Additional paid-In capital Retained eamings, 1/1/18 Total lab and owners' equity S (505,000) (655,000) $ (340,000) (700,000) Given PO2-29 PO2-34 Given PO2-34 Given P02-28 PO2-29 PO2-28 ect destination and press ENTER or choose Paste 4+ 144 AutoSave Off Chapter 2 Excel Assign File Home Insert Draw Page Layout Formulas Data Review View Help X 10 A A Arial 20 Wrap Text Paste I U A Mere Cnte $ % Clipboard Font Allignment Num A1 Given Data PO2-28: A E C E F G H 1 Given Data PO2-28: 2 MARSHALL COMPANY Tucker Company outstanding common stock acquired by Marshall Company Long-term liabilities issued by Marshall for acquisition Marshall Company's $1 par common stock issued for acquisition- number of shares Fair market value of Marshall stock Fees paid by Marshall for arranging acquisition Stock issuance costs paid by Marshall Tucker Company inventory - undervalued Tucker Company land - undervalued Tucker Company buildings - undervalued 100% S 200,000 20,000 8 S 10 11 $ $ 10 30,000 12,000 5,000 20,000 12 13 14 15 S 30,000 16 17 Marshall Tucker Company 18 Company 19 Book Book Value 20 Value S 60,000 $ 270,000 360,000 200,000 420,000 160,000 21 22 Cash Receivables 20,000 90,000 140,000 180,000 220,000 50,000 (40,000) (200,000) 23 24 Inventory Land 25 26 Buildings (net) Equipment (net) Accounts payable Long-term liabilities Common stock - $1 par Common stock - $20 par Additional paid-in capital Retained earnings, 1/1/18 27 28 (150,000) (430,000) (110,000) 29 30 (120,000) 31 32 (360,000) (420,000) (340,000) 33 PO2-28 Given P02-28 PO2-29 Given P02-29 PO2-34 Given PO2-34 Select destination and press ENTER or choose Paste D Chapter 2 Excel Assignement (1) Excel AutoSave O O Search Help Review View Formulas Data Draw Page Layout File Home Insert X 10 A A 8 Wiap Tet Arial Conditional $ % F Paste A . Formatting Alignment Number Font Cipboand fi C1 H F A Problem 02-28 MARSHALL COMPANY Part a. Marshall and Tucker Consolidated Balances 7 Marshall's acquisition of Tucker represents a bargain purchase because the fair value of the net assets acquired exceeds the fair value of the consideration transferred as follows: 10 11 12 Fair value of net assets acquired Fair value of consideration transferred Gain on bargain purchase 13 14 15 16 17 Record three transactions that occurred to create the 18 business combination: 19 20 MARSHALL COMPANY General Journal Credit Debit Account 28 (To recond habioes and stock issued for Tuckor acquistion far value) 30 31 32 33 (To recond aere of orofessional foosl Given PO2-28 34 Given PO2-34 PO2-34 PO2-29 Given PO2-29 PO2-28 Select destination and press ENTER or choose Paste IO AutoSave OR) Chapter 2 Excel Assignement (1) Excel File Home Insert Draw Page Layout Formulas O Search Data Review View Help A A Arial 2 Wrap Text 10 Paste $-% Cond Forma BIU A . Clipboard Font Alignment Number fi C1 C D E 24 Account Debit Credit 25 26 27 28 30 (To record liabildes and slock issued for Tucker acquisition fair value) 31 (To record payment of professional fees) 38 (To record payment of stock issuance costs) 39 Marshall's trial balance is adjusted for the transactions (as shown in the worksheet that follows). 40 41 42 Consideration transferred at fair value Book value (assets minus liabilities or stockholders' equity) Book value in excess of consideration transferred 43 44 45 46 47 Allocation to specific accounts based on 48 49 fair value: 50 Inventory 51 Land 52 Buildings Gain on bargain purchase (excess net asset fair value over consideration transferred) 53 55 PO2-29 Given PO2-28 Given PO2-29 PO2-34 Given PO2-34 PO2-28 Select destination and press ENTER or choose Paste e Chapter 2 Excel Assignement (1) Excel AutoSave Of O Search Help Review View Insert Formulas Data Draw Page Layout File Home X 2 Wrap Text 10A A Arial Cond $ % 8 Paste A BIU Forma Number Alignment Font Cipboard C1 H E F D C A 56 Account Name Cash Balance Explanation 57 58 59 60 Receivables 61 62 63 64 65 Inventory 66 67 Land 68 69 70 71 Buildings 72 Equipment 73 74 75 76 Total Assets 77 78 Accounts Payable 79 BC 81 Long-term Liabilities 82 83 84 Common Stock 85 86 87 Additional Paid-In Capital Given PO2-28 88 Given PO2-34 Given PO2-29 PO2-29 PO2-34 PO2-28 Select destination and press ENTER or choose Paste AutoSave Chapter 2 Excel Assignement (1)- Excel File Home Insert Draw Page Layout Formulas Search Data Review View Help t0A A Arial tWp Te Paste A Conditional Foma as Cell $ %6 % Ins FomangTableSyle Cipboand Font Alignment Number Syles c1 A F G H Additional Paid-in Capital 88 90 Retained Eamings 91 92 Total Liabilities & Equity 94 95 97 98 99 Part b. Marshall and Tucker Consolidated Worksheet 100 101 102 103 104 105 106 107 108 109 110 111 112 MARSHALL COMPANY AND CONSOLIDATED SUBSIDIARY Consolidation Worksheet January 1, 2018 Marshall Tucker Company 20,000 90,000 140,000 180,000 Consolidation Entries Debit Consolidated Accounts Cash Receivables Inventory Land Company Credit Totals 270,000 360,000 200,000 Buildings (net) Equipment (net) Investment in Tucken 420,000 160,000 220,000 50,000 113 114 115 116 117 118 119 Total assets 700,000 S1410,000 $ s (150,000) Accounts payable Long-term labilities Common stock Ad dinani PO2-28 (40,000) (200,000) (120,000) Given PO2-28 PO2-29 Given P02-29 PO2-34 Given PO2-34 Select destination and press ENTERor choose Pate Pham 144 6 AutoSave (OR) Chapter 2 Excel Assignement (1)- Excel Fle Home Insert Draw Page Layout Formulas Data Search Review View Help 10 A A Arial Wp Tt Paste BIU FER Conditional Fomat as Cell FormatsingTbleStyles $-% Cipboand Font Alignment Number Styles 1 D H Part b. Marshall and Tucker Consolidated Worksheet MARSHALL COMPANY AND CONSOLIDATED SUBSIDIARY Consolidation Worksheet January 1, 2018 Marshall Company Tucker Company 20,000 90.000 140,000 180,000 220,000 50,000 Consolidation Entries Debit Consolidated Accounts Credit Totals Cash Receivables Inventory Land Buildings (net) Equipment (net) Investment in Tucker 270,000 360,000 200,000 420,000 160,000 700,000 Total assets $1,410,000 $ (40,000) (200,000) (120,000) Accounts payable Long-term liabilities Common stock (150.000) $ Additional paid-In capital Retained eamings, 1/1/18 Total lab and owners' equity S (505,000) (655,000) $ (340,000) (700,000) Given PO2-29 PO2-34 Given PO2-34 Given P02-28 PO2-29 PO2-28 ect destination and press ENTER or choose Paste 4+ 144 AutoSave Off Chapter 2 Excel Assign File Home Insert Draw Page Layout Formulas Data Review View Help X 10 A A Arial 20 Wrap Text Paste I U A Mere Cnte $ % Clipboard Font Allignment Num A1 Given Data PO2-28: A E C E F G H 1 Given Data PO2-28: 2 MARSHALL COMPANY Tucker Company outstanding common stock acquired by Marshall Company Long-term liabilities issued by Marshall for acquisition Marshall Company's $1 par common stock issued for acquisition- number of shares Fair market value of Marshall stock Fees paid by Marshall for arranging acquisition Stock issuance costs paid by Marshall Tucker Company inventory - undervalued Tucker Company land - undervalued Tucker Company buildings - undervalued 100% S 200,000 20,000 8 S 10 11 $ $ 10 30,000 12,000 5,000 20,000 12 13 14 15 S 30,000 16 17 Marshall Tucker Company 18 Company 19 Book Book Value 20 Value S 60,000 $ 270,000 360,000 200,000 420,000 160,000 21 22 Cash Receivables 20,000 90,000 140,000 180,000 220,000 50,000 (40,000) (200,000) 23 24 Inventory Land 25 26 Buildings (net) Equipment (net) Accounts payable Long-term liabilities Common stock - $1 par Common stock - $20 par Additional paid-in capital Retained earnings, 1/1/18 27 28 (150,000) (430,000) (110,000) 29 30 (120,000) 31 32 (360,000) (420,000) (340,000) 33 PO2-28 Given P02-28 PO2-29 Given P02-29 PO2-34 Given PO2-34 Select destination and press ENTER or choose Paste D