all work needs to be done under that question excel file consolidated worksheet is u 633085

10 15 20 20 20 15 100 2555500 1120000 3675500 64400 64400 33000 33000 2652900 1120000 3772900 1730000 690500 2420500 654500 251000 905500 72000 72000 0 0 2384500 1013500 3398000 268400 106500 374900 636333 139500 775833 268400 106500 374900 100000 60000 160000 804733 186000 990733 119500 132000 251500 342000 125000 467000 362000 201000 563000 40500 517000 557500 150000 150000 477733 477733 825000 241000 1066000 -207000 -53000 -260000 0 294000 294000 2403733 1163000 3566733 295000 32000 327000 304000 19000 323000 600000 600000 -24000 -24000 1000000 300000 1300000 0 50000 50000 804733 186000 990733 0 2403733 1163000 0 0 3566733 0 0 0 0 Template 0 0 1 0 2 0 3 0 4 0 5 0 6 0 7 0 8 0 9 0 10 0 11 0 12 0 13 0 Sales Equity in sub earnings Total revenues Cost of goods sold Expenses Total expenses Net income RETAINED EARNINGS STATEMENT Retained Earnings 1/1 Dividends declared Retained Earnings 12/31 BALANCE SHEET Cash Inventory Total assets Accounts payable Common stock Retained earnings Total liabilities and equity INCOME STATEMENT P CO. S CO. CONS.TOT. Paid in capital Other current assets DR. CR. ELIMINATIONS Noncontrolling interest in sub Accounts receivable Land Investment in S Property and equipment Accumulated depreciation Other liabilities MFG formula Interest income-bonds Interest expense-bonds Investment in S bonds Bonds payable Discount on bonds payable Loss on bonds extinguishment Paul Company acquired 100% of the outstanding common stock of On the acquisition date, Saul Company had retained earnings in the amount of $60,000, and the fair value of its recorded assets and liabilities was equal to their book value. The excess of cost over the fair value of the recorded net assets was attributed to an unrecorded manufacturing formula held by Saul Company, which original cost of $100,000 and accumulated depreciation of $50,000) to Saul Company for…