Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please use excle to solve Thank you 5. Halliburton company is one of the leading Oil company in Oman. The company is has started oil
Please use excle to solve Thank you
5. Halliburton company is one of the leading Oil company in Oman. The company is has started oil refinery in Sohar in Oman. You are the accountant of Sohar region. Your management wants you to prepare the financial statement in such a way, easy for them to understand. You are required to present the Trial Balance and the Financial statements after incorporating the adjustments in a single statement using excel. The following are the details of the Trial Balance for the company. (10 marks) Sr No Particulars Amount (RO) 1 Revenue 16,950,000 Term Loan 1.800.000 3 Accounts Receivable 2.625,000 4 Cash and Bank 507,600 S 28,285 6 32.450 7 66,985 6.250 9 6,000,000 10 11,851,800 11 6,600,000 12 1.050,000 13 874,800 Conveyance expense Insurance expense Discount Income Maintenance Expense Factory Machines Cost Purchases Building Premises Term Deposits Salaries Selling and Dist exp Accounts Payables Repair & Renewals Telephone Expense Petrol Expense Bills payables Profit on sale of property Directors Fees Income Tax 14 1.000.000 15 2.196.000 16 45,520 18.900 17 18 13,800 19 56,000 20 22.220 21 40,325 19.995 22 23 Income from Investment 60,320 Return Outward 348.000 25 Commission Income 88,500 26 525.000 27 28 Legal reserve Accumulated Depn- Machines Share Capital Returns inwards Carriage Outwards 1.200.000 9,000,000 796,500 751.800 29 30 Adjustments to be made for the year end. 1) Depreciation on Factory machines was 20% 2) Provision for Doubtful Debts is to be made @ 3% on closing receivables 3) Closing stock was RO 120,000 4) Insurance prepaid during the year was RO 12,350 5) Outstanding Telephone expense was RO 1.100 9/10 Formatting guidelines: Headings font: Type Times of Roman; Size = 14. Bold Others font: Type = Times of Roman: Size = 12 Column width: 25 Wrap text for headings Merge and center cells: Main Heading, All the cells for amounts = category=Number; Decimal places and Use 1,000 separator Shade the cells in the Heading row Light Purple Using the formula for calculationStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started