Question 3.

The following is the Ledges Balance of Asif traders for the year ended December 31, 2019.

Name of Accounts	Amounts	Name of Accounts	Amounts
Copyright	1,361,646	Computer Equipment	5,018,280
Furniture and Fixtures	1,373,049	Carriage inward	156,589
Cash at bank	13,402,193	Accumulated depreciation - Furniture and Fixtures	288,795
Bills Receivable	2,663,380	General reserve	812,175
Share capital	26,185,500	End of service benefits	883,324
Share premium	158,529	Accumulated depreciation Computer Equipment	277,217
Bills Payables	3,560,441	Sales	11,362,588
15 % Loan	440,789	Retained earning	1,223,544
Purchases	8,616,775	Opening Stock	469,424
Return outward	81,327	Rent & Taxes	118,027
Wages	148,032	Prepaid Insurance	69,828
Salary	5,522,749	Interest on Loan	170,555
Return inward	79,740	Audit fees	98,632
Plant & Machinery	5,214,504	Carriage outward	95,455
Equipment	1,187,565	Legal reserve	492,193

The following additional information as at 31^st December 2019 is available

1. Salaries and wages are outstanding OMR 90,000 and OMR 175,000 respectively
2. Insurance Expenses. OMR 55,000
3. The Furniture and Fixtures is to be depreciated at 18 per cent of cost
4. Computer Equipment is to be depreciated at 15% per annum using the straight-line method.

stament Computer Application in Finance version-E - Word O Search t References Mailings Review View Help The following additional information as at 31st December 2019 is available 1. Salaries and wages are outstanding OMR 90,000 and OMR 175,000 respectively 2. Insurance Expenses. OMR 55,000 3. The Furniture and Fixtures is to be depreciated at 18 per cent of cost 4. Computer Equipment is to be depreciated at 15% per annum using the straight-line method. 5. Stock on 31 Dec 2019 RO 130,000. Required: Prepare the "Extended Adjusted Trial Balance" of the company in an Excel Worksheet. ( 10 Marks) Formatting guideline: Worksheet font:- Type = Type=Calibri Size=10/ Category=Number: Decimal places#0 and Use 1,000 separator