Al Kamyani 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.

Adjustments

1) Closing stock was RO 60,000

2) Depreciation on Plant was 25%

3) Commission income accrued for RO28,000

4) Contribution to the employee gratuity fund for RO 250,000

5) Insurance Prepaid was RO 425

Can you answer in excel program? Thank you very much.

excel. The following are the details of the Trial Balance for the company. Sr No Particulars Amount (RO) Land, Property 8,800,000 2 Investment in Associates 1,400,000 1 3 Salaries 1,166,400 4 1,400,000 5 Selling and Distribution expense Sundry Creditors Return Outward 2,928,000 6 464,000 7 Commission Income 118,000 8 700,000 Employees Gratuity fund Accumulated Depreciation - Plant 9 1,600,000 10 85,400 11 35,460 12 25,840 Renewals expense Telephone Expense Petrol Expense Bills payables Profit on sale of property Equity Share Capital 13 105,200 14 41,500 16 12,000,000 22,600,000 17 Sales 6 18 Bank Muscat - Loan 2,400,000 3,500,000 19 Sundry Debtors 20 Cash and Bank 676,800 21 Plant and Machinery-Cost 8,000,000 22 Purchases 15,802,400 23 Returns inwards 1.062,000 24 Carriage Outwards 1,002,400 25 Insurance expense 5,675 26 6,540 Telephone expense Discount Income 27 13,465 28 1.250 Repair Expense Directors Fees 29 80,325 30 Income Tax 45,325 31 Income from Investment 125,650