Technology Use computer spreadsheet software such as Excel to analyze the following information. Assume the balance sheet of Tran and Nizami’s partnership appeared as follows when they closed the business:

Assets Cash $18,000 Merchandise 40,000 Fixtures and Equipment 24,000 Land and Building 108,000 Total (Use formula here)

Claims Against Assets Accounts Payable (Liabilities) $10,000 N. S. Tran, Capital 90,000 A. J. Nizami, Capital 90,000 Total (Use formula here)

When selling the assets, the partners sold the merchandise for

$32,000, the fixtures and equipment for $18,000, and the land and building for $110,000. After paying their debts, what amount of the remaining cash should each partner receive? Show the formulas you used in your spreadsheet.