The partnership of Wilson Cho and Arrington has the folowing account account information

Wilson Capital balance $200,00040\%$ share of profit and losses

Cho Capital balance $180,00020\%$

Arrington capital balance $110,00040\%$

The partnership will be liquidated and the partners are schedule to receive cash equal to any positive capital balances If a negative capital balance results the partner is expected to contribute that amount.

Assume the losses of $50,000$ occur during the liquidation followed later by additional and final loss of $100,000$

Create a spreadsheet to determine the capital balances that remain for each of the three partners after these two losse are incurred

Modify the spreadsheet so that it can be used for different capital balances different allocation patterns and different liqudation gains and losses