Question 4. The following is the ledges Balance of Sohar LLC for the year ended December 31* 2019. Name of Accounts Amounts Name of Accounts Amounts Sales 8,233,760 General reserve 588,532 Commission Income 886,626 End of service benefits 640,090 Opening Stock 340,162 Plant & Machinery 3,778,626 Purchases 6,244,040 Equipment 860,554 Return outward 58,933 Land & buildings 3,636,435 Wages 107,269 Copyright 986,700 4.001.992 Furniture and Fixtures 994,963 Return inward 57,783 Cash at bank 9,711,734 Goodwill 85,527 Bills Receivable 1,929,985 Prepaid Insurance 50,600 Share capital 18,975,000 Interest on Loan 123,591 Share premium 114,876 Audit fees 71,473 Bills Payables 2,580,029 Carriage outward 69,170 15 % Loan 319,413 Carriage inward 113,471 Legal reserve 356,662 Accumulated depreciation - Plant & Accumulated depreciation - Machinery 209,271 Equipment 200,882 Salary 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 25,000 3. The Plant & Machinery is to be depreciated at 20 per cent of cost 4. Equipment is to be depreciated at 15% per annum using the straight line method. 5. Stock on 31 Dec 2019 RO 100,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 Border the Statement is using I cone "All borders" Using the formula for calculation / All the cells for amounts Column width: - A=51/B,C,E,F.H.,K,L,N,O = 15 / (D.GJ.M = 0.5 Theme colors White Backgrounds, Darker 20%) Headings: - Main Heading Bold, Font Size 12,/ Sub Heading Bold Font Size 11./ Theme colors White, Background, Darker 25% / Merge and center cells: Formula:- Using the formula for calculation like Total / profit and loss / other calculations