Needs to be done on excel.

Part A (2019) Partnership A, B, and C is a law firm. You have been engaged as accountant to prepare financial statements for the year ended December 31, 2019. The partnership's trial balance is shown on the "2019 Tr. Bal." page (see tab below). 'Salary expenses' listed on the trial balance are each partners' withdrawals for the year. Partnership profits are allocated based first on salaries, then on interest on opening capital balances, then on a fixed ratio. Salary allocation amounts are: $100,000 $100,000 $160,000 Opening capital balances are: $70,000 $60,000 $70,000 Interest rate is: 5% The fixed ratio is: Required 1 Prepare year-end adjusting entries. No descriptions are necessary 1 3 2 Allocate partnership profit or loss to each partner. Prepare the necessary adjusting entry. 3 Post the adjusting entries and complete the trial balance. 7 4 Prepare an income statement and statement of partners' capital for the year ended December 31, 2019 and a balance sheet at December 31. 8 Part B (2020) a. On December 31, 2020 new partner D invests other assets into the partnership for a one- quarter ownership interest. An equal amount of capital is contributed by A, B, and C to make up the difference. At December 31, 2020, the partners' capital balances are as $200,000 180,000 190,000 $ 570,000 Fair value of other assets from D $50,000 . Immediately after this, partner withdraws from the partnership. She is paid in cash the balance in her capital account plus a bonus, contributed equally from the capital balances of A, B, and D. Bonus paid to C $ 18,000 Required 5 Prepare necessary adjusting entries at December 31, 2020 to record the admission of partner D and the withdrawal of partner C. Show all calculations. Part (2021 and 2022) WN The trial balance of A, B, and D at December 31, 2021 after all adjustments have been made is as follows: Adjusted Balances Account Title Debit Credit Cash 83,000 Other Assets 80,000 Accounts Payable 140,000 A, Capital 7,000 B, Capital 7,000 C, Capital 9,000 163,000 163,000 On January 1, 2022 the partnership is liquidated. Other assets are sold for: $ 144,000 Gains and losses are liquidated in a ratio of: UN Required 6 Print out the "Part. Liqu." page (see tab below). Complete the schedule. Assume any partner deficiency (debit balance) is repaid with cash by the applicable partner. 7 Prepare the journal entries to record the liquidation. A, B, and C GENERAL JOURNAL Description Debit Credit Total Amount of profit Salary allocation Balance Interest allocation: Opening cap. Rate Balance Fixed ratio allocation Balance Allocated to partners A, B, and C Trial Balance At December 31, 2019 Adjusting Entries Debit Credit # Adjusted Balances Debit Credit # Unadjusted Balances Debit de Credit 80,000 300,000 80,000 110,000 100,000 Account Title Cash Accounts Receivable Accounts Payable A, Capital A, Withdrawals B, Capital B, Withdrawals C, Capital C, Withdrawals Income Summary Fees Revenue Office Expense Salaries Expense - A Salaries Expense - B Salaries Expense - 200,000 790,000 500,000 150,000 120,000 130,000 1,280,000 1,280,000 A, B, and C Income Statement For the Year Ended December 31, 2019 A B, and C Statement of Partners' Capital For the Year Ended December 31, 2019 Bal. at Jan 1, 2019 Bal. at Dec 31, 2019 A, B, and C Balance Sheet At December 31, 2019 Liavilities Partners'Eixsin A, B, and D Statement of Partnership Liquidation For the Day Ending January 1, 2022 Cash Other assets Accounts payable Partners' capital Opening balance Allocation of gain (loss) Amount Ratio