Instruction: Answer all the questions. Each question carries five (10) marks (5Q 10M - 50 MARKS) Question 1. The following is the Ledges Balance of Khalid Traders for the year ended December 31, 2019. Name of Accounts Amounts Name of Accounts Amounts Opening Stock 408,195 Carriage inward 136,165 Accumulated depreciation - Purchases 7,492,848 Equipment 251,126 Return outward 70,719 General reserve 706,239 Wages 128,723 End of service benefits 768,108 Salary 4,802,390 Plant & Machinery 4,534,351 Share capital 22,770,000 Equipment 1,032,665 Share premium 137,851 Vehicles 4,363,722 Bills Payables 3,096,035 Copyright 1.184,040 15 % Loan 383,295 Furniture and Fixtures 1,193,956 Legal reserve 427,994 Cash at bank 11,654,081 Accumulated depreciation- Vehicles 241,058 Bills Receivable 2,315,982 Sales 9,880,512 Return inward 69,339 Commission Income 1,063,951 Rent & Taxes 102,632 Audit fees 85,767 Prepaid Insurance 60,720 Carriage outward 83,004 Interest on Loan 148,309 The following additional information as at 31" 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 Equipment is to be depreciated at 15 per cent of cost 4. Vehicles is to be depreciated at 10% per annum using the straight-line method. 5. Stock on 31 Dec 2019 RO 150,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 and Use 1,000 separator Border the Statement is using Icone "All borders" Using the formula for calculation / All the cells for amounts Column width:- B.C.E.F.H.UK.L.NO 15/(D.GJ.M.05 Theme colors White Background, Darker 2012 Headings: Main Heading Bold, Pont Size 12,/ Sub Heading Bold Font Size 11./Theme colors White Background Darker 25%/ Merre and consells Formulas - Using the formula for calculation like Total profit and loss / other calculations Page 1