I have already posted this question, as many others have, but I still need parts 6 (statement of partnership liquidation) and 7 (journal entries) explained and set up in an excel format. Thank you.

A, B, and D

Statement of Partnership Liquidation

For the Day Ending January 1, 2022

Other assets

Accounts payable

Cash

Partners' capital

A

B

D

The trial balance of A, B, and D at December 31,2021 after all adjustments have been made is as follows: On January 1, 2022 the partnership is liquidated. Other assets are sold for: Gains and losses are liquidated in a ratio of: Required 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. Prepare the journal entries to record the liquidation