3. Al Kursi LLC is a leading business across Oman. The company is owned by family and has family members as their share holders. They are now planning to go for further expansion of the activity so as to increase the goodwill in the market. To make the financial statement easy to understand you are required to present the Trial Balance and the Financial statement in a simple and single statement using excel. The following are the details of the Trial Balance for the company. (10 marks) Sr No Particulars 1 Amount (RO) 11,300,000 4,400,000 700,000 Revenue Building Premises Term Deposits Salaries 2 3 4 583,200 5 700,000 1,464,000 6 Selling and Dist exp Accounts Payables Directors Fees Income Tax 7 26,883 8 13,330 9 Income from Investment 40,213 10 232,000 11 59,000 12 350,000 Return Outward Commission Income Legal reserve Accumulated Depn-Machines Share Capital Returns inwards 13 800,000 6,000,000 14 15 531,000 16 Carriage Outwards 501,200 17 Term Loan 1.200,000 18 Accounts Receivable 1,750,000 19 Cash and Bank 338.400 18,857 20 Conveyance expense 21 Insruance expense 21.633 22 Discount Income 44,657 23 4.167 24 4,000,000 25 7.901,200 26 42.500 Maintenacne Expense Factory Machines -Cost Purchases Repair & Renewals Telephone Expense Petrol Expense Bills payables Profit on sale of property 27 17,340 28 12,420 29 55,200 30 17,060 Adjustments 1) Closing stock was RO 80.000 2) Depreciation on Machine was 25% 3) Insurance Prepaid for RO 6,350 4) Provision to be made for Doubtful Debts @ 4% on closing receivables. 5) Outstanding Salaries were RO 7,800 Formatting guidelines: Headings font: Type = Bookman Old Style: Size = 14, Bold Others font: Type = Bookman Old Style; Size = 12 Column width: 25 Wrap text for headings Merge and center cells: Main Heading, All the cells for amounts = category=Number; Decimal places=0 and Use 1,000 separator, Shade the cells in the Heading row = Light Yellow Using the formula for calculation