No Excel please

Q.3 X, Y and Z were partners sharing profits in the proportion of 3:2:1. Y Retires from the business. The Balance sheet of the firm on the date of retirement was as follows Liabilities Amount(RO) Assets Amount(RO) Creditors 20,000 Cash at Bank 5,000 Bills Payable 10,000 Stock 15,000 General Reserve 15,000 Debtors 20,500 20,000 -Provision 500 Capital Vehicle 25,000 Accounts X 40,000 Machinery 70,000 Y 30,000 z 20,000 135,000 135,000 It was agreed among the partners 1. Goodwill of the firm to be valued at RO 24,000 2. Stock to be depreciated by 10% and Van by 20% 3. Provision for Doubtful debts to be increased by RO 1,000 4. Liability for Outstanding expenses of RO 1,900 to be brought into account 5. Machinery to be appreciated by 10% Record the necessary Journal Entries and Prepare the necessary accounts and New Balance sheet of X and Z