with computation in excel

Problem: As of Deember 31,2016, the books of AME partnership showed capital balances of Anna, P40,000.00; Mina, P25,000.00 and Emma, P5,000.00. The partners profit and loss ratio was 3:2:1 respectively. The partners decided to dissolve and liquidate. They sold all the noncash assets for P37,000.00 cash. After settlement of all liabilities amounting to P12,000.00, they still have P28,000.00 cash left for distribution. Question No. 2. The loss on realization of the noncash assets was: a. P42,000.00 b. P40,000.00 C. P45,000.00 d. Answer not given Question No. 3. Assuming that any debit balance of partners' capital is uncollectible, the share of Anna on P28,000.00 cash for distribution was: a. P19,000.00 b. P17,800.00 c. P18,000.00 d. Answer not given