Excel Type. Installment liquidation (Cash Priority Program and Safe payment method)

Installment liquidation (Cash Priority Program and Safe payment method) D. E and F are partners sharing profits in the ratio of 40:35:25, respectively. On December 31, 2006, they agree to liquidate. A balance sheet prepared on this date follows: DEF Partnership Balance Sheet As of December 31, 2006 Cash Other Assets 2,000 46,000 Liabilities E, Loan F, Loan D, Capital E, Capital F, Capital total 6,000 5,000 2,500 14,450 12,550 7,500 48,000 total 48,000 The results of liquidation are summarized below. Realization Book Value Cash Realized Expenses of Realization Cash Wheld at end of month for estd. Future exps. Liability Paid January February March April 4,000 2,000 12,000 7,000 15,000 12,000 10,500 6,000 10,000 4,000 500 750 600 400 2,000 1,250 500 All cash available, except the amount withheld for future expenses, is distributed at the end of each month. Required: Determine the share of each partner every month of distribution