AutoSave OFF QEU = Pepper & Salsa Year 3 Workpaper (2) View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments Arial v 22 vi A General I A7 4 Conditional Formatting 12 Format as Table & Cell Styles v vo LL Insert X Delete v Format v TV Paste B I U BV Ideas $ % ) Sensitivity Sort & Filter Find & Select A35 fix On December 31, Year 1, Pepper Company acquired 100% of the common stock of Salsa Company, at book value, by Issuing 15,000 shares of Pepe's $2 par common A N Salsa Company 180.000 G Consolidation Entries Dobit Credit Item Sales 4 Income from Subsidiary G Cost of Goods Sold 6 Depreciation and Amortization 7 Other Expenses Pepper Company 836,000 (19,000) 476,000 70,000 Consolidated 1,016,000 (19,000) 574.000 20.000 90,000 281,000 180,000 B1,000 91,000 (19.000) 72,000 10 Net Income 11 12 Retained Earnings, January 1 13 Net Income # Dividends Declared 345,000 91,000 45,000 155.000 (19.000) 8,000 500,000 72,000 15 53,000 519,000 391,000 128.000 18 Retained Earnings, December 31 17 16 Current Assels Te Buildings & Equipment 20 Land 21 Investment in Salsa Co Stock 482,000 520,000 175,000 328,000 275.000 310,000 50.000 757,000 830,000 225,000 254,000 1,759,000 92.000 727.000 328,000 346,000 2,486,000 20 Other Assets 24 Total Debits 25 28 Accumulated Depreciation 27 Accounts Payable 28 Bonds Payable 2e Common Stock 30 Additional Paid-In Capital 31 Retained Earnings 32 Total Credits 238,000 100,000 180,000 150 000 700,000 391,000 113.000 136,000 150.000 20,000 180.000 128.000 727,000 351,000 235,000 330,000 170,000 880,000 519,000 2,486,000 1,759.000 0 0 33 On December 31, Year 1, Pepper Company acquired 100% of the common stock of Salsa Comnany at book value by issuing 15.000 shares of Pene's $2.nar common 12-31-X3 + Use the mouse to apply the copied format to another object Elu + 75% AutoSave OFF QEU = Pepper & Salsa Year 3 Workpaper (2) View Tell me Home Insert Draw Page Layout Formulas Data Review Share Comments Arial v 22 ~ A General I'49- 4 Conditional Formatting Format as Table Cell Styles vo SE Insert X Delete v Format v TV Paste B I U BV $ % Ideas Sensitivity Sort & Filter Find & Select A35 fix On December 31, Year 1, Pepper Company acquired 100% of the common stock of Salsa Company, at book value, by Issuing 15,000 shares of Pepe's $2 par common B H N 482,000 520,000 175,000 328,000 275,000 310.000 50.000 757,000 830,000 225,000 254,000 1,759,000 92.000 727,000 320,000 346,000 2,485,000 18 Current Assets 19 Buildings & Equipment 20 Land 21 Investment in Salsa Co. Stock 22 23 Other Assets 24 Total Debits 25 28 Accumulated Depreciation 21 Accounts Payable 2 Bonds Payable 29 Common Stock 30 Additional Paid-In Capital 31 Retained Earnings 32 Total Credits 33 34 238,000 100,000 180,000 150,000 700,000 391,000 1,759,000 113.000 136.000 150.000 20.000 180.000 128 000 727,000 351,000 238,000 330,000 170,000 880,000 519,000 2,486,000 On December 31, Year 1, Pepper Company acquired 100% of the common stock of Salsa Company, at book value, by issuing 15,000 shares of Pepe's $2 par common At December 31, Year 1 and Year 2, Salsa owed Pepe $10,000 on account. There were no intercompany receivables/payables at 12/3/1Year 3. 35 Required: Prepare the consolidation workpapers for Years , 3, 43 41 42 48 45 12-31-X3 + Use the mouse to apply the copied format to another object El u + 75%
