please complete the consolidation worksheet

Pavin acquires all of Stabler's outstanding shares on January 1, 2015, for $660,000 in cash. Of this amount, $50,000 was attributed to equipment with a 10-year remaining life and $60,000 was assigned to trademarks expensed over a 20-year period. Pavin applies the partial equity method so that income is accrued each period based solely on the earnings reported by the subsidiary. On January 1, 2018, Pavin reports $500,000 in bonds outstanding with a carrying amount of $464,000. Stabler purchases half of these bonds on the open market for $241,000. During 2018, Pavin begins to sell merchandise to Stabler. During that year, inventory costing $160,000 was transferred at a price of $200,000. All but $30,000 (at sales price) of these goods were resold to outside parties by year-end. Stabler still owes $53,000 for inventory shipped from Pavin during December. The following financial figures are for the two companies for the year ending December 31, 2018. Dividends were both declared and paid during the current year. $ Pavin (800,000) 475,000 145,000 56,000 Stabler $ (545, 000) 260,000 178,500 0 (24,000) $ $ Revenues Cost of goods sold Expenses Interest expense-bonds Interest income-bond investment Loss on extinguishment of bonds Equity in Stabler's income Net income Retained earnings, 1/1/18 Net income Dividends paid Retained earnings, 12/31/18 Cash and receivables Inventory Investment in Stabler Investment in Pavin bonds Land, buildings, and equipment (net) Trademarks Total assets Accounts payable Bonds payable Discount on bonds Common stock Retained earnings (above) Total liabilities and stockholders' equity (130,500) (254,500) (365,000) (254,500) 175,000 (444,500) 237,000 195,000 684,500 $ (130,500) $ (401,000) (130,500) 97,000 $ (434,500) $ 55,000 107,000 $ $ 265,000 245,000 561,000 $ 1,381,500 $ (128,000) (500,000) 20,000 (329,000) (444,500) $ (1,381,500) $ 968,000 $ (273,500) (120,000) 0 (140,000) (434,500) $ (968,000) Note: Credits are indicated by parentheses. Prepare a worksheet to produce consolidated balances. (For accounts where multiple consolidation entries are required, combine all debit entries into one amount and enter this amount in the debit column of the worksheet. Similarly, combine all credit entries into one amount and enter this amount in the credit column of the worksheet. Amounts in the Debit and Credit columns should be entered as positive. Negative amounts for the Consolidated Totals column should be entered with a minus sign.) Consolidated Totals Accounts Revenues Cost of goods sold Expenses Interest expensebonds Interest incomebond investment Loss on extinguishment of bonds Equity in income of Stabler Net income Retained earnings, 1/1/18 Retained earnings, 1/1/18 Net income Dividends paid Retained earnings, 12/31/18 Cash and receivables PAVIN AND STABLER Consolidation Worksheet For Year Ending December 31, 2018 Consolidation Entries Pavin Stabler Debit Credit $ (800,000) $ (545,000) 475,000 260,000 145,000 178,500 56,000 0 0 (24,000) 01 or (130,500) $ (254,500) $ (130,500) (365,000) (401,000) (254,500)| (130,500) 175,000 97,000 $ (444,500) $ (434,500) $ 237,000 $ 55,000 195,000 107,000 684,500 245,000 265,000 561,000 Inventory Investment in Stabler Investment in Pavin Land, buildings, and equipment (net) Trademarks Total assets Accounts payable Bonds payable Discount on bonds Common stock $ $ 1,381,500 (128,000) (500,000) 20,000 (329,000) 968,000 (273,500) (120,000) (140,000) Retained earnings Total liabilities and stockholders' equity (444,500) $ (1,381,500) (434,500) (968,000) $