could you post on a spreadsheet

Help S ! Required information {The following information applies to the questions displayed below) Turner, Roth, and Lowe are partners who share income and loss in a 23.5 ratio (in percents Turner, 20%, Roth, 30%, and Lowe 50%) The partners decide to liquidate the partnership. Immediately before liquidation, the partnership balance sheet shows total assets, $154,800, total liabilities. $102,000. Turner, Capital, $4.900, RothCapital $15,200, and Lowe, Capital, $32.700 Cash received from selling the assets was sufficient to repay all but $40,000 to the creditors Required: 6. Calculate the loss from selling the assets b. Allocate the loss from part a to the partners. c. Determine how much each partner should contribute to the partnership to cover any remaining capital deficiency Complete this question by entering your answers in the lahe hain TUSS ITON dil de parties. c. Determine how much each partner should contribute to the partnership to cover any remaining Complete this question by entering your answers in the tabs below. 2.55.35 Required A Required B Required Calculate the loss from selling the assets, Liabilities before liquidation Proceeds from sale of assets (pald to creditors) Remaining liabilities Proceeds from sale of assets Book value of assets sold Recured B earch Complete this question by entering your answers in the tabs below. the partnership to cover any remaining capital deficiency. 18 Required A Required B Required Allocate the loss from part a to the partners. (Losses and deficits should be indicated with a minus sign Initial capital balances Allocation of gains (losses) Captal balances after gains (losses) Tumer 4,900 Roth $15.200 Lowd 32.700 Total 52 800 Required A Required) tion by entering your answers in the tabs below. deficienc Required A Required B Required Determine how much each partner should contribute to the partnership to cover any rerfiaining capital deficiency. Amount to be contributed to the partnership Turner Roth Lowe Total Required B