2024 – Complete the following exercise Fill in the Excel spreadsheet provided via the link at the

Complete the following exercise. Fill in the Excel spreadsheet provided via the link at the bottom of the page to enter your answers to parts a, b, and c. Then paste the Excel data into a Word document on which you can also write the answer to part d.

Label each exercise or problem clearly. Use APA formatting and citation if needed.

Sand, Mell, and Rand are partners who share incomes and losses in a 1:4:5 ratio. After lengthy disagreements among the partners and several unprofitable periods, the partners decided to liquidate the partnership. Before the liquidation, the partnership balance sheet showed the following:

• Cash $10,000
• Total “other assets,” $106,000
• Total liabilities, $88,000
• Sand, Capital, $1,200
• Mell, Capital, $11,700
• Rand, Capital, $15,100

The “other assets” were sold for $ 85,000.

Determine the following:

1. The gain (or loss) realized on the sale of the assets.
2. The balances in the partners’ capital accounts after the distribution of this gain or loss to the capital accounts.
3. Assume that if any capital deficits exist, they are not made up and the deficient partner pays down his or her deficit to zero. How much cash will each of the partners receive in the final liquidation?
4. Provide an explanation between 200 and 300 words in length of the requirements for liquidating the partnership. What documents will be needed? How will the money be distributed? What other options might there be in place of liquidation?