If you could please solve this question using the pictures provided and if you make your own tables, make them look like the one's in the picture, It throws me way off track if done otherwise. Thank you very much.

Ch 12 Student Assign-1 (I Protected View - Excel Unlicensed Product Michael N. Sampogna al Fie Home Insert Page Layout Foucas Dals Review View Help Tell me what you want to du 2. Share T13 A D E F G H J K M N 0 S U V w 1 2 3 4 5 6 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. 9 10 11 12 13 14 Salary allocation amounts are: A $100,000 B $100,000 $160,000 15 Opening capital balances are: A $70,000 B $60,000 $70,000 Interest rate is: 5% The fixed ratio is: 2 B 3 C 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 23 34 35 16 37 36 19 Required 1 Prepare year-end adjusting entries. No descriptions are necessary. 2 Allocate partnership profit or loss to each partner. Prepare the necessary adjusting entry. 3 Post the adjusting entries and complete the trial balance. 4 Prepare an income statement and statement of partners' capital for the year ended December 31, 2019 and a balance sheet at December 31. Requ. 1 to 4 Requ. 5 Requ. 6 to 7 Gen. Jnl. Allor. Trial Bal Fel. Stmts. Part. Liqu Copyright - + 100% Type here to search O E 3:12 PM 7/10/2020 21 19 Ch 12 Student Assign-1 (1: Protected View] - Excel (Unlicensed Product Michael N. Sampogna Fie Home Insert Page Layout Formulas Data Review View Help Telt what you wanillu du 2. Share R6 > fo A B C D E F M N P R S T V Part 8 (2020) 1 2 3 4 5 6 7 B 9. 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 follows: $200,000 B 180,000 C 190,000 $570,000 A Fair value of other assets from D $50,000 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 b. 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. 27 28 29 30 31 32 33 34 35 36 37 38 Requ. 1 to 4 Requ. 5 Requ. 6 to 7 Gen. Jnl. Allor. Trial Bal Fel. Stmts. Part. Liqu Copyright 1 - + 100% Type here to search O E 3:12 PM 7/10/2020 21 Ch 12 Student Assign-1 (1) Protected View] - Excel (Unlicensed Product: Michael N. Sampogna Fie Home Insert Page Layout Foucas Data Review View Help Tell me what you wanillo du Share M11 D E F H - M P R T U B Part C (2021 and 2022) 1 2 3 The trial balance of A, B, and D at December 31, 2021 after all adjustments have 4 been made is as follows: 5 Adjusted Balances 6 Account Title Debit Credit 7 Cash 83,000 B Other Assets 80,000 9 Accounts Payable 140,000 10 A, Capital 7,000 11 B, Capital 7,000 12 C, Capital 9,000 13 163,000 163,000 14 15 On January 1, 2022 the partnership is liquidated. 16 Other assets are sold for: $144,000 17 18 Gains and losses are liquidated in a ratio of: 19 A 3 20 B 2 21 D 5 22 23 24 Required 256 Print out the "Part. Liqu." page (see tab below). Complete the schedule. Assume any 26 partner deficiency (debit balance) is repaid with cash by the applicable partner. 257 Prepare the journal entries to record the liquidation, 29 30 31 32 33 34 35 36 37 Requ. 1 to 4 Requ. 5 Requ. 6 to 7 Gen. Jnl. Allor. Trial Bal Fel. Stmts Part. Liqu Copyright - + 100% Type here to search O E 3:13 PM 7/10/2020 21 Ch 12 Student Assign-1 (1) Protected View] - Excel (Unlicensed Product: Michael N. Sampogna al Fic Home Insert Page Layout Formulas Data Review View Help Tel me whal you wanillu du 2. Shame A1 A D E F G H L M N 0 P 1 A, B, and GENERAL JOURNAL 2 3 4 Description Debit Credit 5 6 7 8 10 11 - 12 1 12 13 14 14 15 13 16 17 18 19 20 21 22 23 24 25 26 27 28 29 10 31 32 33 34 35 Requ. 1 to 4 Requ. 5 Requ. 6 to 7 Gen. Jnl. Allor. Trial Bal Fol. Stmts Part. Liqu Copyright - + 100% Type here to search 0 3:13 PM 7/10/2020 21 Ch 12 Student Assign-1 (1: Protected View] - Excel (Unlicensed Product Michael N. Sampogna al Fie Home Insert Page Layout Formulas Data Review View Help Tel in what you wanillu du 2. Share A1 fo A B D E F G - H L K N M O P 0 - R 1 8 C Total 2 3 4 5 6 Amount of profit Salary allocation Balance Interest allocation: 7 Opening cap. 8 Rate 9 A 10 11 12 13 14 B Balance Fixed ratio allocation A B Balance Allocated to partners 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Requ. 1 to 4 Requ. 5 Requ. 6 to 7 Gen. Jnl. Alloc. Trial Bal Fel. Stmts Part. Liqu Copyright 1 - + 100% Type here to search 0 3:14 PM 7/10/2020 21 Ch 12 Student Assign-1 (1: Protected View] - Excel (Unlicensed Product Michael N. Sampogna al Fie Home Insert Page Layout Formulas Data Review View Help Telt what you waitillo du & Share C27 B G HI M N 0 P s 1 2 3 4 CE F A, B, and c Trial Balance At December 31, 2019 Adjusting Entries Debic Credit Adiusted Balances Debit Credit # Unadjusted Balances Debit Credit 90,000 400,000 40,000 120,000 170,000 160,000 870,000 5 6 Account Title 7 Cash 8 Accounts Receivable 9 Accounts Payable 10 A, Capital 11 A, Withdrawals 12 B, Capital 13 B, Withdrawals 14 C, Capital 15 C, Withdrawals 16 Income Summary 17 Fees Revenue 18 Office Expense 19 Salaries Expense. A 20 Salaries Expense - B 21 Salaries Expense C 22 23 24 25 26 27 25 29 30 31 32 33 34 35 36 500.000 130,000 140,000 100,000 1,360,000 1,360,000 28 29 Requ. 1 to 4 Requ. 5 Requ. 6 to 7 Gen. Jnl. Allor. Trial Bal. Fel. Stmts Part. liqu Copyright - + 100% Type here to search 0 3:15 PM 7/10/2020 21 19 Ch 12 Student Assign-1 (1: Protected View] - Excel (Unlicensed Product Michael N. Sampogna al Fie Home Insert Page Layout Formulas Dals Review View Help Telme what you wanillu du 2. Share A1 fo A B D F G H 0 K M N P R S T U 1 2 A, B, and c Income Statement For the Year Ended December 31, 2019 4 5 6 7 8 9 10 11 A, B, and c Statement of Partners' Capital For the Year Ended December 31, 2019 B Total Bal. at Jan 1, 2019 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Bal. at Dec 31, 2019 A, B, and Balance Sheet At December 31, 2019 Assets Liabilities 29 30 31 32 33 34 35 36 37 Partners' Equity 36 39 40 41 42 Requ. 1 to 4 Requ. 5 Requ. 6 to 7 Gen. Jnl. Allor. Trial Bal Fcl. Stmts. Part. liqu Copyright - + 100% Type here to search 0 3:15 PM 7/10/2020 21 Ch 12 Student Assign-1 (1: Protected View] - Excel (Unlicensed Product Michael N. Sampogna Fie Home Insert Page Layout Formulas Data Review View Help Tell me what you wanillu du 2. Share A1 A D E F . 1 K M N O R S T U V w X Y 1 2 3 4 5 6 A, B, and D Statement of Partnership Liquidation For the Day Ending January 1, 2022 Accounts payable 7 Cash Other assets Partners' capital B D 8 9 Opening balance 10 11 Allocation of gain (loss) Amount 12 Ratio A 13 14 B D 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Requ. 1 to 4 Requ. 5 Requ. 5 to 7 Gen Jnl. Allor. Trial Ball. Fol. Stmts. Part. Liqu. Copyright - + 100% Type here to search O E 3:16 PM 7/10/2020 21 Ch 12 Student Assign-1 (I Protected View - Excel Unlicensed Product Michael N. Sampogna al Fie Home Insert Page Layout Foucas Dals Review View Help Tell me what you want to du 2. Share T13 A D E F G H J K M N 0 S U V w 1 2 3 4 5 6 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. 9 10 11 12 13 14 Salary allocation amounts are: A $100,000 B $100,000 $160,000 15 Opening capital balances are: A $70,000 B $60,000 $70,000 Interest rate is: 5% The fixed ratio is: 2 B 3 C 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 23 34 35 16 37 36 19 Required 1 Prepare year-end adjusting entries. No descriptions are necessary. 2 Allocate partnership profit or loss to each partner. Prepare the necessary adjusting entry. 3 Post the adjusting entries and complete the trial balance. 4 Prepare an income statement and statement of partners' capital for the year ended December 31, 2019 and a balance sheet at December 31. Requ. 1 to 4 Requ. 5 Requ. 6 to 7 Gen. Jnl. Allor. Trial Bal Fel. Stmts. Part. Liqu Copyright - + 100% Type here to search O E 3:12 PM 7/10/2020 21 19 Ch 12 Student Assign-1 (1: Protected View] - Excel (Unlicensed Product Michael N. Sampogna Fie Home Insert Page Layout Formulas Data Review View Help Telt what you wanillu du 2. Share R6 > fo A B C D E F M N P R S T V Part 8 (2020) 1 2 3 4 5 6 7 B 9. 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 follows: $200,000 B 180,000 C 190,000 $570,000 A Fair value of other assets from D $50,000 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 b. 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. 27 28 29 30 31 32 33 34 35 36 37 38 Requ. 1 to 4 Requ. 5 Requ. 6 to 7 Gen. Jnl. Allor. Trial Bal Fel. Stmts. Part. Liqu Copyright 1 - + 100% Type here to search O E 3:12 PM 7/10/2020 21 Ch 12 Student Assign-1 (1) Protected View] - Excel (Unlicensed Product: Michael N. Sampogna Fie Home Insert Page Layout Foucas Data Review View Help Tell me what you wanillo du Share M11 D E F H - M P R T U B Part C (2021 and 2022) 1 2 3 The trial balance of A, B, and D at December 31, 2021 after all adjustments have 4 been made is as follows: 5 Adjusted Balances 6 Account Title Debit Credit 7 Cash 83,000 B Other Assets 80,000 9 Accounts Payable 140,000 10 A, Capital 7,000 11 B, Capital 7,000 12 C, Capital 9,000 13 163,000 163,000 14 15 On January 1, 2022 the partnership is liquidated. 16 Other assets are sold for: $144,000 17 18 Gains and losses are liquidated in a ratio of: 19 A 3 20 B 2 21 D 5 22 23 24 Required 256 Print out the "Part. Liqu." page (see tab below). Complete the schedule. Assume any 26 partner deficiency (debit balance) is repaid with cash by the applicable partner. 257 Prepare the journal entries to record the liquidation, 29 30 31 32 33 34 35 36 37 Requ. 1 to 4 Requ. 5 Requ. 6 to 7 Gen. Jnl. Allor. Trial Bal Fel. Stmts Part. Liqu Copyright - + 100% Type here to search O E 3:13 PM 7/10/2020 21 Ch 12 Student Assign-1 (1) Protected View] - Excel (Unlicensed Product: Michael N. Sampogna al Fic Home Insert Page Layout Formulas Data Review View Help Tel me whal you wanillu du 2. Shame A1 A D E F G H L M N 0 P 1 A, B, and GENERAL JOURNAL 2 3 4 Description Debit Credit 5 6 7 8 10 11 - 12 1 12 13 14 14 15 13 16 17 18 19 20 21 22 23 24 25 26 27 28 29 10 31 32 33 34 35 Requ. 1 to 4 Requ. 5 Requ. 6 to 7 Gen. Jnl. Allor. Trial Bal Fol. Stmts Part. Liqu Copyright - + 100% Type here to search 0 3:13 PM 7/10/2020 21 Ch 12 Student Assign-1 (1: Protected View] - Excel (Unlicensed Product Michael N. Sampogna al Fie Home Insert Page Layout Formulas Data Review View Help Tel in what you wanillu du 2. Share A1 fo A B D E F G - H L K N M O P 0 - R 1 8 C Total 2 3 4 5 6 Amount of profit Salary allocation Balance Interest allocation: 7 Opening cap. 8 Rate 9 A 10 11 12 13 14 B Balance Fixed ratio allocation A B Balance Allocated to partners 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Requ. 1 to 4 Requ. 5 Requ. 6 to 7 Gen. Jnl. Alloc. Trial Bal Fel. Stmts Part. Liqu Copyright 1 - + 100% Type here to search 0 3:14 PM 7/10/2020 21 Ch 12 Student Assign-1 (1: Protected View] - Excel (Unlicensed Product Michael N. Sampogna al Fie Home Insert Page Layout Formulas Data Review View Help Telt what you waitillo du & Share C27 B G HI M N 0 P s 1 2 3 4 CE F A, B, and c Trial Balance At December 31, 2019 Adjusting Entries Debic Credit Adiusted Balances Debit Credit # Unadjusted Balances Debit Credit 90,000 400,000 40,000 120,000 170,000 160,000 870,000 5 6 Account Title 7 Cash 8 Accounts Receivable 9 Accounts Payable 10 A, Capital 11 A, Withdrawals 12 B, Capital 13 B, Withdrawals 14 C, Capital 15 C, Withdrawals 16 Income Summary 17 Fees Revenue 18 Office Expense 19 Salaries Expense. A 20 Salaries Expense - B 21 Salaries Expense C 22 23 24 25 26 27 25 29 30 31 32 33 34 35 36 500.000 130,000 140,000 100,000 1,360,000 1,360,000 28 29 Requ. 1 to 4 Requ. 5 Requ. 6 to 7 Gen. Jnl. Allor. Trial Bal. Fel. Stmts Part. liqu Copyright - + 100% Type here to search 0 3:15 PM 7/10/2020 21 19 Ch 12 Student Assign-1 (1: Protected View] - Excel (Unlicensed Product Michael N. Sampogna al Fie Home Insert Page Layout Formulas Dals Review View Help Telme what you wanillu du 2. Share A1 fo A B D F G H 0 K M N P R S T U 1 2 A, B, and c Income Statement For the Year Ended December 31, 2019 4 5 6 7 8 9 10 11 A, B, and c Statement of Partners' Capital For the Year Ended December 31, 2019 B Total Bal. at Jan 1, 2019 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Bal. at Dec 31, 2019 A, B, and Balance Sheet At December 31, 2019 Assets Liabilities 29 30 31 32 33 34 35 36 37 Partners' Equity 36 39 40 41 42 Requ. 1 to 4 Requ. 5 Requ. 6 to 7 Gen. Jnl. Allor. Trial Bal Fcl. Stmts. Part. liqu Copyright - + 100% Type here to search 0 3:15 PM 7/10/2020 21 Ch 12 Student Assign-1 (1: Protected View] - Excel (Unlicensed Product Michael N. Sampogna Fie Home Insert Page Layout Formulas Data Review View Help Tell me what you wanillu du 2. Share A1 A D E F . 1 K M N O R S T U V w X Y 1 2 3 4 5 6 A, B, and D Statement of Partnership Liquidation For the Day Ending January 1, 2022 Accounts payable 7 Cash Other assets Partners' capital B D 8 9 Opening balance 10 11 Allocation of gain (loss) Amount 12 Ratio A 13 14 B D 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Requ. 1 to 4 Requ. 5 Requ. 5 to 7 Gen Jnl. Allor. Trial Ball. Fol. Stmts. Part. Liqu. Copyright - + 100% Type here to search O E 3:16 PM 7/10/2020 21